Excel import to ISAM database issue

[Michael514]

Hi All,

On a tight deadline and was told I would have an Excel spreadsheet to import. Unfortunately the file given to me is a fixed length text file with 60+ fields. Easy enough to do a simple import, but I will be given the same file every two weeks with about 14,000 lines each. I would like to automate the data import. The Wizard in excel allows me to do the import but not save for file format. Once imported there will be a number of additional steps, which I'll work on once I've settle a automated import.

Is there anywhere I can find a simple tutorial to script the data import given it's a fixed length text file

 

[SkipVought]

hi,

I am a bit confused.

Are you importing a fixed length text file into Excel, or are you importing and Excel sheet into another database?

I think it may be the former. If so, this is a ONE TIME SETUP, using Data > Import External Data > IMPORT... using the FIXED option, and specifying your parsing specifications.

This adds a QueryTable to you sheet, that can be refreshed to import a new dataset using the stored querytable specifications.

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]