Help With Importing Txt File

[MaDoyle]

I hope someone can help

I have the following code i am using to import a text file

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "TblInitialSalesData", "H\Retail Network\Public\0800Plan\Ops Team\4760\Branch_Report - 6-13-08 6'09'18 AM.txt", NO

when i try to run the code i get a error message saying "external table not in expected format". The table is set up with 74 fields and each field is in text format and is just names F1 through to f74

regards

 

[DCrake]

Simple Software Solutions

If you run this through a macro or the wizard do you still get the same error?

 

[MaDoyle]

Yes, i have just been checking some other threads and people seem to have the problem when the tables is linked but my is just a nomal table

 

[DCrake]

Simple Software Solutions

What are you saying Yes to?

 

[MaDoyle]

sorry yes i still get the error when i try the other ways of importing the data

 

[gemma-the-husky]

is the spreadsheet actually open in excel

that would give you an error i think

also what does acSpreadsheetTypeExcel9 do,?

there are other excel optionsd - perhaps you need a different one

----------
to import to an existing table, all the column heads have to match exactly - perhaps thats the problem also