import from excel to access with macro?

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

Have existing access table.
Imported data from the following source.
C:\Documents and Settings\jw\Desktop\[error_report_play.xls]Sheet3

Need macro in access that will return to the same data location and
copy all of the data to the next available row in the table.
 
You need to use ADODB Recordsets to do that via a macro. It is not distinctly
difficult but it does require a bit of know how.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Best way to get data from Access 2003 to Excel 2003 6
Importing several web pages with macro/VBA? 9
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Create a Macro to Import External Data 0
Excel to Access - User needs Access installed? 1
Macro to import multiple sheets 2
Importing Data from Access Query to Excel Sheet 4

Back
Top