Import excel

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

Guest

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?
 
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?
 
Back
Top