Transfer Spreadsheet

[Matt]

Hi

I am running the flowing code to import an excel Spreadsheet in to an
existing table that has filed names

DoCmd.TransferSpreadsheet acImport, , "Table1", "c:\temp.xls", False

And I get this error

Run-time error 2391

Field ‘F1’ Doesn’t exist in destination ‘table1’

 

[Stefan Hoffmann]

hi Matt,

I am running the flowing code to import an excel Spreadsheet in to an
existing table that has filed names
DoCmd.TransferSpreadsheet acImport, , "Table1", "c:\temp.xls", False
And I get this error
Run-time error 2391
Field ‘F1’ Doesn’t exist in destination ‘table1’

The field names in your table are not the same as in your Excel sheet.

Create a import specification using the import wizard and use it with
the TransferSpreadsheet method (see OH).


mfG
--> stefan <--

 

[Matt]

Hi

Where dose the import wiser hid in access 2003 and what is see OH
Thanks

Matt

 

[Stefan Hoffmann]

hi Matt,

Where dose the import wiser hid in access 2003 and what is see OH

Just import your file manually (Files/External data). There is button in
the left-bottom corner of the import wizard (maybe called more).

OH: online help.


mfG
--> stefan <--