Programatically Import Spreadsheet

D

Duck

Is there a way to use either VBA or a macro to automatically import a
spreadsheed and append the data to an existing table. Please bear in
mind that I am very new when it comes to VBA, but I have an urgent
requirement to be able to accomplish something of this nature.
 

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

Importing any excel files with any sheet name into different tables in MSAccess using code 0
Macro for Import of data 1
Spreadsheet import/update to normalised database. 4
TransferText question 2
How to Create a Macro to Import External Data 0
Access 2000 and Visual basic for Applications problem 1
Access Importing csv daily files into access 2007 1
Import Excel Spreadsheet 1

Top