I need someone to create and MS Access Database or Excel Macro Process that I can use daily to import a CSV file attached (Ridgeview Release) to into an excel sheet attached (Excel Trial file). The issue is that the CSV file is not in collumns and rows it contains a mix of data. Preview CSV attached
Please do not bid if you think it's a quick Data import. You will have to understand Macros and Data conversions to do this project. Preview the attached file first.
IN SUMMARY:
TAKE THE DATA FROM CSV FILE AND CONVERT IT THEN IMPORT IT INTO AN ACCESS DATABASE. I NEED A DATABASE OR EXCEL MACRO BOOK THAT I CAN USE TO DO THIS EVERYDAY.
HAPPY BIDDING!
THANK YOU!
Hi,
I have more 10 years experience in MS Access and Office automation, so I'm realy GURU in this.
I can help you with this project.
Best Regards,
Alex
Hello,
I am a VB programmer and this task is easy for me, I will develop an Excel VBA macro that you can use every day to import data from that CSV to Excel.
Best wishes,
Emmett.
I've been working with Access for > 10 years, and I realize how to perfom your job. Plan is to make Delphi program to analyze your text file and create Access database.