Auto Imort Table

[Nick34]

I want to import data from a spreadsheet automatically. How can I tell access to import a particular range of the spreadsheet, as in range("A15",range("A15").end(xldown).offset(-3,0))??? I want access to append this data to the bottom of an existing table in my database. Is this possible? I am trying to use the transfer spreadsheet method but am having no luck.

Thanks for any help.

 

[lewds]

Hi..

I am not an Access wizard, and do not have a one step process answer,but this works for me.

1. Use the TransferSpreadsheet method to get the data into an Access table ( a Temp table)

2. Create an Append Query to get the data from the Temp table to the table you want.

3. Create a Delete Query to empty your Temp table.

4. Combine the above under a command button or some other event.