Completed

Modify MS Access database to import CSV files.

Currently have import tool that assists the end user during import of spreadsheet. (e.g. spreadsheet is imported and processed in Access). The tool assists the end user in mapping the columns of the spreadsheet to specific tables in the database. **** Currently the database is hard coded to look for the spreadsheet in a predefined folder (C:\Access), with a predefined name ([url removed, login to view]) for the spreadsheet.

What we want now: Keep the column mapping, and add end user ability to "browse" or "navigate" and chose what folder to search in for the spreadsheet. We would like the end user to be able to chose a spreadsheet with any name (not simply the hard coded "[url removed, login to view]"). It would be nice to have the "browse window" show all spreadsheets and CSV file in the folder (ignoring files with endings like pdf, jpg, etc.... and only show xls, xlsx, csv, etc....).

Skills: Microsoft Access

See more: what is ms access, microsoft spreadsheets, csv spreadsheet, MS Access Database, import csv, C# access, c access, spreadsheet csv, import tool, import modify, modify access, import files folder, jpg xls, csv pdf, modify mapping, pdf import csv, import jpg, csv column mapping, import csv database, microsoft access modify database, csv xls access, xlsx pdf, pdf xlsx, import file mapping column, report xls

About the Employer:
( 37 reviews ) Sultan, United States

Project ID: #6398761

Awarded to:

CARLOSHUGGINS

i will add this functionality..... Thanks for considering my proposal..... Im a 12 year experiencedVBA Developer

$90 USD in 3 days
(9 Reviews)
4.7

9 freelancers are bidding on average $156 for this job

expertcoder1vw

I'm an expert Access / VBA developer and can make the required change to browse for files for you. To import CSV files there is some VBA coding to be done, as the existing code to import XLS files would be different More

$147 USD in 2 days
(22 Reviews)
5.4
bob1982

hi i am very good in access and excel programming i have read the description and quite sure i am able to do the work with desired accuracy Regards

$155 USD in 3 days
(50 Reviews)
4.7
swapnilchavan18

Hi, I am interested to work on this project and provide you best output. I have 5 years of experience in it . Let discuss about the project.

$200 USD in 5 days
(6 Reviews)
4.0
sonarkaushik

A proposal has not yet been provided

$194 USD in 5 days
(3 Reviews)
2.9
oobretenov

I could help you. . . . .

$155 USD in 3 days
(1 Review)
1.8
SoftwareEng8876

Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [login to view URL] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..

$250 USD in 3 days
(2 Reviews)
0.0
zakirahmouni

Aucune proposition n'a encore été fournie.

$155 USD in 1 day
(0 Reviews)
0.0
abdolah2014

HI I am an excel-vba and also vb expert and I can help you with your project pm me ..................................................................................................

$155 USD in 5 days
(0 Reviews)
0.0
shahinrezaodesk

A proposal has not yet been provided

$155 USD in 3 days
(0 Reviews)
0.0
almosb

I am a System Administrator with over 11 years experience. I am also experienced in MS Office (Word, Excel, Access etc.) Before I become System admin, and after, I created many databases, applications in Access for my More

$145 USD in 3 days
(0 Reviews)
0.0