I am looking for an MSExcel/MSAccess developer to create an importer for ms access to import comma-separated CSV files.
This importer needs to store the CSV data into an MS Access database.
The database is used for a electronics (phones, mp3 players, digital cameras) repair & recycling company, to store customer information (name, address, contact details) and some additional information about the devices sent in for repair (type of device, manufacturer, model name/number, working/notworking, price). furthermore, it will be used to track processing of the devices (working/not working -> need to send email, email sent/not sent, device processed, send email notification for payment).
The specialty is that people get paid by us if they recycle their phones, but if they only want to repair it, they will be invoiced (through a different system).
This should give you an idea of the requirements.
More detailed requirements will follow once there is a winning bid.
Please provide me with references or examples of your work; I will not select you if you cannot provide this.
You should select me, because, i am the most experienced (yet, in this bidding), i have 32 EXCELLENT project reviews, My bid amount is minimum in experienced coders, i completed many Excel projects for my clients (see my profile), and in GAF, i am well known for my fast delivery. Thanks. -TUHIN
This can be solved in easy way by using the combination between VBA and ADO/DAO. I may need an hour or two only. Send me the sample of CSV and MS Access Database/Excel Worksheet, and I will send back with the completed solution
Please note the above bid is an approximation.
I need to see the foll.
"have an example EXCEL with macros that needs to be converted into an access DB (access 2003) to provide fucntionality as per description above.
i also have a sample CSV file that will have to be imported"
to be able to assess scope of work and submit my final bid.
We are a team of developers with immense expertise and experience in Visual Basic 6 and can do a very good job for you.
Although new to this site we are ranked 15th on RAC and have completed many projects successfully.