Export excel table to acess table using VBA Code

  • Thread starter Thread starter Jof
  • Start date Start date
J

Jof

I need to export data from excel into access. I cant link the file from
access, as the excel data is saved in a different location everytime.

I run a macro to format the data, and would like the VBA code to append
the data into an access table at the end of this formatting code.

I can import the files but cant automate it from access as the file
path is different everytime.

Any ideas?
 
You can use ADO to send an SQL command to append your Excel data to an Access
table. I have written a couple responses to other posts in the past week to
this same issue; if you do a search for Dales Access I think you will find
the info you need; if not let me know and I will post the info again for you.
 

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

How to export table from outlook into ms access table? 0
Importing any excel files with any sheet name into different tables in MSAccess using code 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
How to copy data from an excel cell into a field in access table 0
VBA - retrieve data on last create named range from previous inserted named range 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
running an Acess Macro from excel 3
Trouble Installing Excel VBA Code Cleaner into Office 365 0

Back
Top