Import Excel Spreadsheet

  • Thread starter Thread starter simoNamibia
  • Start date Start date
S

simoNamibia

Part 1.
I'm sure this topic has been covered a million times but I'm still not
clicking. I know there are easier ways to import data into Access 2007 but
they aren't helping me in my never-ending quest to learn the SQL syntax. All
I want to do is import data from an Excel spreadsheet into an existing table
- yes they do have the exact same format!

Part 2.
The Excel file in question has been created by running a macro on a bit of
field data also saved in Excel - how about running that same macro from
Access (yes - at the click of a button) instead of going into Excel and doing
it???

Tnx in advance
 
1. Yes. Use docmd.transferspreadsheet acimport, "Name of spreadsheet","Path
to spreadsheet",true
2. The command button wizard will create that for you automatically. Do that
and then look at the code it created.
 
Back
Top