Uploading Excel Data into Access With a Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have been trying to create a macro in excel to automatically export data
into access, but to no avail. Would somebody please give me a hint?
Your assistance will be greatly appreciated.

Thanks
 
If you want to do it in EXCEL macro, I recommend that you post to an EXCEL
newsgroup. If you want to get the EXCEL data while running ACCESS, check out
the TransferSpreadsheet action in an ACCESS macro (note: ACCESS macros are
not VBA code).
 
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

Export Excel Data to Access With a Macro!!! 3
Zero Upload Speed 6
Q: Working with Embedded Excel Worksheets 2
Access #Error & Excel Pivot 0
Create a Macro in Excel from Access 5
Upload Word document into Access 6
Scheduling 2
Excel Data Transfer Issue (strange situation) 1

Back
Top