code for auto import from excel to Access97

[sparky]

Thanks for the previous help.

I now need some direction in setting code to automatically import data from
excel into Access97.

I have set up my queries for the import, and it works like a champ. Before I
can run that query, I have to manually import the excell data into a
specially named table. I would like a command that would allow the
importing of the excel data (.csv) into the specially named table, then
append that data into 3 seperate tables, which is done using my queries.

I would like this command to be placed in one of my "switchboard" menus, but
I don't see the correct way to do this, short of building code.

If I have to build code to do this, I was hopeing someone could spell it out
for me, as I don't have any code knowledge.

Let's call the data to be imported from excel "exceldata", and the Access
table it is imported into "Table1". The 3 tables that the data will be
appened into will be called "Table2", "Table3" and "Table 4". Of course,
these are not the real names, but used to make this posting easier.

Anyone able to direct me to the correct way to do this?

Thanks in advance.

Rick Miell

 

[Ken Snell \(MVP\)]

Check out the TransferText action for a macro, or the DoCmd.TransferText
method for VBA.