Import

[nicola1]

Hi all,

At the moment i am trying to produce a button which my users can click on to import some data from Excell to Access.

When i just go through it manually, ie file> import etc, the table fom Excel appears in access perfectly, but when i try using my button it brings up the following message:

Field 'F1' doesn't exist in the destination table 'Sheet2'.

The button runs off a macro. This is what i have for each option:

Action:TransferSpreadsheet

Transfer type: Import
Spreadsheet type:Microsoft Excel 3
Table name:Sheet2
File name:the file location
Has filed names:No
Range:

I would be grateful if anyone could help and let me know where i am going wrong.

Thankyou

 

[reclusivemonkey]

I swear I just replied to this...

OK is Sheet2 the worksheet you want to import from or the table you are importing to? Because in your macro you are referencing the table to import to as Sheet2. I would give the range a name in excel, make sure you have field names, then make Has FIELD Names = YES and include the Range Name in the macro.

 

[nicola1]

Thank you very much...that worked perfect.

 

[dreamz]

thanks, this was really useful to me aswelll