vb code to export data into existing Access table

  • Thread starter Thread starter desperate
  • Start date Start date
D

desperate

HELP!

Can anyone help me out with code that will export data
from Excel into an Access Table that areadly exists? The
Excel data and Access data are identical in terms of
fields and properties. THANKS!
 
----- desperate wrote: ----

HELP

Can anyone help me out with code that will export data
from Excel into an Access Table that areadly exists? The
Excel data and Access data are identical in terms of
fields and properties. THANKS

Can you import the excel spreadsheet into Access instead of exporting from excel
You can write the same vba code in access as in excel I thought so here is th
command to import a spreadsheet into an access table.

lsSheet2 = "\\n0qcpfs1\redirect$\ndmlj1\MyDocuments\AIS.xls
DoCmd.TransferSpreadsheet acImport, 8, "T - AISBuyer", lsSheet2, Tru

The 8 is the default in Access2000 for a spreadsheet created in at least Excel v8
If you want to export I would suppose you'd have to open the access database from th
excel vba and then use acExport

I hope this at least gets you thinkin'. Hope it helps.
 
Back
Top