excell Q

[hairy]

I need to import an excell file everyday, first how do you do it, second can the file name be used everyday, ie trend.xls?

[BobWeaver]

Go to the Import Records item in the File menu. Under file type, select Excel. Pick the file. Click Ok. Select whether the first row is field names or data. Select your import order. Voila.

Next, go into scriptmaker create a new script called "Import". Clear all the default script steps except the first "go to browse mode". Add an Import records step with no dialog, but select the file name. This will set the file name and default the import order to the one you just did. Now, you can run this script everyday and it will import new records from the excel file.