Excel To MDB

V

VBAlexander

Hi
I Export Empty MDB table to Excel with this command
DoCmd.OutputTo

Now I get this XLS file with new rows that I need append to my MDB Table
What is the ways to do it?

What I do now...
I check MDB tables Fields for their type generate INSERT SQL statement With
data from XLS
And run SQL

Maybe some body know other ways?
 

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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Excel To MDB 1
Sorting Multiple Tables 1
Export Access Table to Excel in different sheet 1
Excel --> Word 4
Transfer data from any mdb file to sql server? 1
Word VBA - Want to test if Full Name is NOT Present in document 0
Excel To MDB 4

Top