F Faraz Ahmed Qureshi Mar 8, 2010 #1 I am using the 2007 version. What would be the correct syntax for importing data from an excel file?
D Dirk Goldgar Mar 8, 2010 #3 Faraz Ahmed Qureshi said: I am using the 2007 version. What would be the correct syntax for importing data from an excel file? Click to expand... Although your subject says "TransferText", if you are actually importing from an Excel workbook, you're going to want to use TransferSpreadsheet. I believe the online help for it is reasonably clear. Post back if you have any questions.
Faraz Ahmed Qureshi said: I am using the 2007 version. What would be the correct syntax for importing data from an excel file? Click to expand... Although your subject says "TransferText", if you are actually importing from an Excel workbook, you're going to want to use TransferSpreadsheet. I believe the online help for it is reasonably clear. Post back if you have any questions.
R ryguy7272 Mar 12, 2010 #4 http://office.microsoft.com/en-us/excel/HP052008521033.aspx http://blogs.howtogeek.com/mysticge...2007-import-microsoft-access-data-into-excel/ If toy want a VBA solution: http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
http://office.microsoft.com/en-us/excel/HP052008521033.aspx http://blogs.howtogeek.com/mysticge...2007-import-microsoft-access-data-into-excel/ If toy want a VBA solution: http://www.accessmvp.com/KDSnell/EXCEL_Import.htm
