Combine my 2613 csv files with same header row into one table in MS Access
- or -
Post a project like this2085
£33/hr(approx. $44/hr)
- Posted:
- Proposals: 20
- Remote
- #2233976
- Completed
Microsoft Access Developer, Access Developer, Access Development, Access Database Developer, MS Access VBA Developer
Paris
Excel | VBA | Macro | MS Access | MS Word | PowerPoint Program | .Net | C# | VB.Net
Bangalore
16587391250408323452144943318894542702693514705158261389976249919522911341652864
Description
Experience Level: Expert
All the CSV files are in one folder on a local machine. I need to import them all into the same table in access so I can filter/query the data as I need to.
The CSv files have 1000 rows of data each.
I have not created the access database or table yet.
I believe the easiest way to do this is to create a VBA script to import all the data into access. I have found some VBA scripts on the internet but can't get them to work.
You may have another method of doing this if so I'm open to other suggestions. I just need to achieve the outcome I don't mind how i get there!
The CSv files have 1000 rows of data each.
I have not created the access database or table yet.
I believe the easiest way to do this is to create a VBA script to import all the data into access. I have found some VBA scripts on the internet but can't get them to work.
You may have another method of doing this if so I'm open to other suggestions. I just need to achieve the outcome I don't mind how i get there!
Justine T.
100% (19)Projects Completed
18
Freelancers worked with
17
Projects awarded
41%
Last project
4 Nov 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Justin
How many CSV files are there? Are they all in the same format? Do they have any key fields in them?
743812
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies