Thanks for your reply
Thanks for your reply but could you indicate in either solution how I can automatically gather the spreadsheet name into the database so I can say that this information that I am checking comes from that spreadsheet (they want to keep the spreadsheets). Most spreadsheets are unchangeable data with new updates put on the January spreadsheet so linking is not necessary.
...
cloa
Last Activity: Jan 23 '10, 10:32 AM
Joined: Jan 22 '10
Location:
-
cloa started a topic Include the spreadsheet name as the first field when importing multiple spreadsheetsin AccessInclude the spreadsheet name as the first field when importing multiple spreadsheets
I have seen the answer for importing multiple spreadsheets though I haven't tried it. How do I include the spreadsheet filename as the first field for all rows. By the way how does this handle if the workbooks are sometimes formated as one worksheet and sometimes two worksheets. The format is generally very similar.
...Code:Function Impo_allExcel() Dim myfile Dim mypath mypath = "n:\importxls\aramiska\"
No activity results to display
Leave a comment: