Read txt file into MS Access table using VBA
$30-250 USD
Paid on delivery
Our company is a service provider in logistics. Quite a bit of our business software is developed using MS Access and VBA.
Presently we need to import a txt file that is generated by a shipping company GLS into an MS Access table.
We would like to do that on a scheduled basis.
So at a specific time the new function can be called and the following should happen:
- check if the txt file exists (function for checking if a file exists is already available)
- read the txt file records and add these in an MS Access table
- Move the txt file to the folder "processed" (function for moving files is available as well)
It is enough to provide a function for importing this txt file. Implementation in the existing MS Access systems will be done by our own IT department.
Kind regards,
Johan
Project ID: #1631415
About the project
Awarded to:
20 freelancers are bidding on average $79 for this job
Hello. We are a team of professionals in developing MS Access +VBA applications. Please check our reviews and examples in your PMB.
Greetings! Expert in MS access technology. Ready to start immediately. Waiting for reply.
Hello Me an Ms-Access Expert working on MS-Access & VBA for the past 10 years. I am ready to do your work and could start right now. I have already done a no. of successful Access Projects and can provide u sample c More
Hi, i can do it. Please send a sample text file and structure of table( s) you want to import to. Which version of access you use? Looking forward to hearing you, Cuong NH
Hello, I see you require an Access macro to add the contents of the specific text files to Access DB table. I understand you only need the function. I have sent your a private message about my skills and previous exper More
Hi, I have over 15 years access development experience, and have coded several TXT and CSV imports in VBA. I can provide this import for you.
