Import Excel Data into Access

  • Thread starter Thread starter sJ
  • Start date Start date
S

sJ

I have data in an excel workbook which in the same layout as my access
table. What is the easiest way to import it via VBA?

TIA
 
Via vba, you would use Docmd.actransferspreadsheet Acimport,, "your file name",
"C:\whatever" , true, "sheet1!A4:d10"
The true is if you have column headers you want to import with the document.
 
I have data in an excel workbook which in the same layout as my access
table. What is the easiest way to import it via VBA?

TIA
Click to expand...

Easiest is to use the Access menu; select File... Get External Data... Import;
select .xls on the "files of type" dropdown, and then your workbook file.

TransferSpreadsheet does the same thing in VBA code and would be better for a
recurring task.
 
You must log in or register to reply here.

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
How to export table from outlook into ms access table? 0
import multiple Excel worksheet into a main Access table 1
Import 4 Different Excel Files from One Folder 0
How can I push Access Data into Excel from Access 2007? 2
Import multiple Excel tabs into access 4
Importing Excel data into Access table 4
export to excel and save 4

Back
Top