Use command button to import new records 1

[haygordon]

I have to import and excel file with 3 columns, all of which match columns in access table1.

The excel file is named newdata.xls and data is in columns a, b and c.

Is there any way I can import this in to table1 with the user simply pressing a command button?

I find that access frequently refuses the data when using the import wizard saying field names do not match, when the always do. This happens frequently when the data is downloaded from another database in to an excel file.

 

[dolfan1873]

make an import table (newdata_tbl), make an append qry from this table to your existing table.

make a macro that imports the newdata.xls (transferspreadsheet), and then run query (your append query).

then all you have to do is run the macro using your command button.