Get data from excel workbook to access table 1

[ietprofessional]

Does anyone have any vba-ado code that will allow me(from an access db) pull data from an excel sheet into an access table.

Thanks!

 

[PHV]

Take a look at the DoCmd.TransferSpreadSheet method.
You may also consider link a worksheet to an access table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ietprofessional]

Thanks PHV but I need code to get data from multiple sheets from a single workbook.

Thanks!

 

[PHV]

And that should be a problem ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ietprofessional]

DoCmd doesn't have a parameter that allows be to choose a specific sheet.

 

[PHV]

But yes, the named parameter Range
Use either named ranges or sheets name like Range:="Sheet2!"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244