try something like this
Sub import_excel_file()
Dim sample_table As String
sample_table = "temp_table_name"
' import a specific range from a worksheet
DoCmd.TransferSpreadsheet acImport, , sample_table,
"C:\Users\ashishkoul\Desktop\learn\sales_detail.xlsx", True,
"sales_detail$a1:d10"
' import who
Hi, suits your situation:
https://app.box.com/s/zxhxpoitad7sih0wpigl
https://app.box.com/s/szaxukie20xnutka8f3e
Basole.
2014/1/23 fahad hassan
> Hey i want to ask a question regarding data transferring from excel to
> access.
> I have 4 excel sheets with data in it. i want to copy each of th
Hey i want to ask a question regarding data transferring from excel to
access.
I have 4 excel sheets with data in it. i want to copy each of the sheet
into a table (which is already existing) in Access.
Can someone please help me with a method to perform this in a single step???
--
Are you =EXP
