DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8

[Boon]

Hello,

I have vba that will import the data from Excel file. Is it possible to
append the data from excel file to a table in Access in such a way that
excel file does not have a field's name? When I run this transferspreadsheet
command, it comes in as F1, F2,.....

thanks,

 

[Piet Linden]

Hello,

I have vba that will import the data from Excel file. Is it possible to
append the data from excel file to a table in Access in such a way that
excel file does not have a field's name? When I run this transferspreadsheet
command, it comes in as F1, F2,.....

thanks,

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
"MyTable", "C:\MyFile.xls", True

Note the TRUE... that means "tell Access that the first row is column
headings, so don't import that.... you must have it set to false.

 

[golfinray]

Put the field names in the first row of the spreadsheet. Then on the
transferspreadsheetmethod, you can tell Access where to start linking or
importing. Like thisoCmd.TransferSpreadsheet acLink, , "0709 payment
tracking", "P:\fileshare\milton 0709 disbursement", True, "sheet1!a2:s595"