Hi All,
This seems like a simple thing, but I can’t seem to figure it out. I am familiar with transferring excel spreadsheets into access using the TransferSpreash eet function Ex:(DoCmd.Trans ferSpreadsheet acImport, 8, "LogTemplat e", "C:\Documen ts and Settings\My Documents\Log template.xls", True, "").
I would like to import several spreadsheets into access without creating the table. I know how to manually import the spreadsheet but how can it be done without assigning a table. I would to import the spreadsheet and then the table created, just like if I was to do it manually. I tried removing the table from the example I have above but I get an error. I know this is probably simple but can’t figure it out. Thanks for any advice.
This seems like a simple thing, but I can’t seem to figure it out. I am familiar with transferring excel spreadsheets into access using the TransferSpreash eet function Ex:(DoCmd.Trans ferSpreadsheet acImport, 8, "LogTemplat e", "C:\Documen ts and Settings\My Documents\Log template.xls", True, "").
I would like to import several spreadsheets into access without creating the table. I know how to manually import the spreadsheet but how can it be done without assigning a table. I would to import the spreadsheet and then the table created, just like if I was to do it manually. I tried removing the table from the example I have above but I get an error. I know this is probably simple but can’t figure it out. Thanks for any advice.
Comment