Import Excel Data into Access

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
 
G

golfinray

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.
 
J

John W. Vinson

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.
 

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 4 Different Excel Files from One Folder 0
import multiple Excel worksheet into a main Access table 1
Import multiple Excel tabs into access 4
export to excel and save 4
Import data from Access to Excel containing VB code 3
Importing Excel data into Access table 4

Top