Import Excel Spreadsheet

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
 
G

golfinray

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.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Data Transfer Issue (strange situation) 1
Import Excel Spreadsheet 1
How to cause a spreadsheet (Excel) to run from an Access Macro 4
Import data from Access to Excel containing VB code 3
Access 2007 Excel Import Error 1
Import Excel comments to field in Access 1
Import to many to many table 7

Top