Excel issues
Excel issues
- Subject: Excel issues
- From: Oakley Masten <email@hidden>
- Date: Thu, 11 Sep 2008 09:17:16 -0700 (PDT)
Hi All
I know this is not the right place to ask but I am hoping someone can direct me to that place.
We are using AppleScripts to run lots of processes and have run into a glitch.
It is not stopping the process but is just annoying.
We have a sql database on a Windows 2003 server [ I don't know the versions but can find out if it would help] that creates a report for these processes.
This report is an Excel doc.
[side bar - this file does not have a "file type" or a "creator type" in it.
Adding the "file type" and "creator type" via AppleScript does not fix the problem.]
the report gets imported into a FileMaker 9 database which is used to drive
several scripted processes.
Now for the glitch.
The FileMaker dBase will not import the Excel data unless it is first opened in Excel, on my Mac running OSX 10.4.11, and then re-saved. [Opening and saving the file using a Windows machine does not fix the problem.]
Then it imports just fine.
An obvious answer might be to use ODBC you say.
I have already said this and was informed that the Mac side would not be allowed to directly interface with the "real computers" on the dark side. I jest, but that was the response with some liberal translation added.
Has anyone had similar issues and if so where do I look to fix this?
Thanks in advance for any insight here
Oakley
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden