Hello Board Members
I was hoping to solicit some help with an import issue. In fact I am trying to end a tedious task.
I have a folder located at c:\raw_keywords\access_import that contains many (100’s) of .csv files. This file will be static. I copy files into this folder for the single purpose of loading into Access. When I am done I move these out. It is just a staging area.
I wish to load and append all files in this directory to “tblKeyword”. Each file is the same format and the exact same column titles. There are 4 columns this is constant.
I have created a form named “Keyword Import” and on that form I have a command button named “cmdMassLoad”. I would like to simply click this and have it load all records into this table.
Optionally, I would like to date stamp each record and also have the file name it came from. For instance if the file path is “c:\raw_keywords\access_import\business 1” then I would like it condensed to just “business 1” ( I do not need the file path but just the individual file name).
The end result will be Column 1 (Autonumber Index) - Column 2 “Date” – Column 3 “File Name” - Column 4 “Keyword” – Column 5 “comp” – column 6 “Global” – Column 7 “Local”
Again these last 4 columns are identical names as each .csv. This table is already set up.
I appreciate any assistance you can render
Thanks
I was hoping to solicit some help with an import issue. In fact I am trying to end a tedious task.
I have a folder located at c:\raw_keywords\access_import that contains many (100’s) of .csv files. This file will be static. I copy files into this folder for the single purpose of loading into Access. When I am done I move these out. It is just a staging area.
I wish to load and append all files in this directory to “tblKeyword”. Each file is the same format and the exact same column titles. There are 4 columns this is constant.
I have created a form named “Keyword Import” and on that form I have a command button named “cmdMassLoad”. I would like to simply click this and have it load all records into this table.
Optionally, I would like to date stamp each record and also have the file name it came from. For instance if the file path is “c:\raw_keywords\access_import\business 1” then I would like it condensed to just “business 1” ( I do not need the file path but just the individual file name).
The end result will be Column 1 (Autonumber Index) - Column 2 “Date” – Column 3 “File Name” - Column 4 “Keyword” – Column 5 “comp” – column 6 “Global” – Column 7 “Local”
Again these last 4 columns are identical names as each .csv. This table is already set up.
I appreciate any assistance you can render
Thanks
