Transfer Spread sheet to BD

S

SAM

Hi,

I'm importing an Excel Sheet to my Access database can I
specify the name of the field and wih field I want to
import

This is what I'm using:

DoCmd.TransferSpreadsheet acImport,
acSpreadsheetTypeExcel9, "Tb_CommandeTemp", sNameFile,
0, "Sheet1!Print_Area"


Thanks
 

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

Import Excel Sheet 1
adding a run macro function 0
Import Two Excel file into a table of Access 2000 3
Access 2003 versus Access 2007 Excel Import 0
Move Files after import 1
Need Help with a VBA subroutine 0
Transfer Spreadsheet Code 2
Problem with DoCmd.TransferSpreadsheet acImport 4

Top