I need a vba macro that will import list into a Access 2010 database.
The applications will need to automatatically detect what kind of info is in each column and organize it into the database format depending on a keyword table.
The expected format will be : name, address, city, postal code, province, phone #, website.
The application would decide to place any keyword equivalent to name (business name, company, business, etc.) into position 1.
Would need also a form that pop-up when unknown keyword is processed.
I need that code ASAP and with a lot of comment to maintain it.
19 freelance font une offre moyenne de $340 pour ce travail
Hi, I made a mapping tool that uploads text files into SQLserver and maps uploaded fields into fields of any chosen unified table. From Sqlserver u can export into access2010 easily. I can show u a demo if u r inter Plus
Hello, How are you? I have techniques and experiences of Access, Excel, Word VBA programming and Office runtime programming. I can do your work in 2 days. I hope i could have a chance to work with you. Best r Plus
I'm a MS Access expert since 2002, MS Excel since 1998, some C++ experience since 1999 and Java since 2006. Let's keep it easy and scalable.
Independent Management Consultant and former Prof. of Strategy with extensive experience in Excel. See PM.
We have expertise in importing data from .xls, .csv, .xml, .txt, .mdb to sql, mysql or any other database or from any format to any format mentioned above. While importing the file(s) we will check the given file is in Plus