vb code to export data into existing Access table
 

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!

vb code to export data into existing Access table
 

----- 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.x ls
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.

vb code to export data into existing Access table
 

Take a look at Mr. Erlandsen's site:

http://www.erlandsendata.no/english/vba/adodao/

--
Regards,
Tom Ogilvy

"MJ in Boston" wrote in message
...


----- 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
the
command to import a spreadsheet into an access table.

lsSheet2 = "\\n0qcpfs1\redirect$\ndmlj1\MyDocuments\AIS.x ls"
DoCmd.TransferSpreadsheet acImport, 8, "T - AISBuyer", lsSheet2, True

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 the
excel vba and then use acExport?

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