Import excel

D

Donna

I need to import data from an excel spreadsheet every day. Is there a way to create a macro that will automate this process? Right now I have to go to File, Import Data, tell it what kind of file to import then tell it what file to import, then deal with all the prompts Access asks for like first row contains headings, into an existing table, what table & finish. It's always the same - how can I create a macro or something to automate this so all I have to do is click a button?
 
J

Jim/Chris

Use the TransferSpreadsheet option in your macro.

Jim

-----Original Message-----
I need to import data from an excel spreadsheet every day.
Click to expand...
Is there a way to create a macro that will automate this
process? Right now I have to go to File, Import Data, tell
it what kind of file to import then tell it what file to
import, then deal with all the prompts Access asks for like
first row contains headings, into an existing table, what
table & finish. It's always the same - how can I create a
macro or something to automate this so all I have to do is
click a button?
 

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

Need Help with Macro Security 1
Excel - Wich Function should I use? 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Import Spreadsheet Problem 3
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Excel to Word to PDF workflow 1
Record Macros in Access 2003? 3

Top