Import from Excel and runtimeError 3709

[DaRTHY]

Hello My Friends,

I wrote so basic a macro and bound up with a Button.

Im exporting Excel Sheet from my companies Program and importing to Access.

Everything is functioning automatically. But when I try to import Excel Sheet Im getting run time error 3709. :banghead:

I checked Import Error and the problem is field names.

Normally the field shall be Text but its converting automatically Integer.

But if I dont use macro and import step by step myself (I dont change field names when i was importing...) then it works just normal.

How can i fix that problem ?

before use my macro Shall I every time update something in Excel Sheet ? Or there is easy way to fix that ??

Many Thanks

 

[Cronk]

If you want help with a macro, please post the code.

Alternatively, I find it easier to link to the Excel spreadsheet as a linked table. Then use queries to import data.

 

[arnelgp]

you have to inspect the excel sheet first before importing, making sure that the column type is the same as with your table's field type.