Data import from Excel into SQL data base with pull down menus... Consistently.?

Question

I have an SQL database that has many data fields. Some of the fields have pull down menus to drive consistency. When I try an upload data from free text fields in Excel into these pull downs the data never matches exactly. It is an extremely manual process to clean up these excel docs to match for import. I need a way to automate this process! Please help!

Answer 1

What you need is a custom piece of software.



I doubt you will find many takers on free. If you want to get some bids on this post it on one of the many freelance sites and accept some bids anon and choose the best one.



Judging from what you need its prob about an hours worth of time. Around a 100USD is what you should expect to pay.



I am not soliciting for this job so do not contact me.

Answer 2

Visual Basic for Application is the way ... then you will do the clean up via some macro



It is not so long to learn it, but it requires stamina ;-)

My best advice, learn it, practice it and you will not regret (beeing a master in Excel have a lot of advantages)



Start today: try to record your clean up using the macro recorder tool. Press ALT+F11 and look at the code. Your challenge is to make the code flexible enough so that it can be used for any import



Good luck

Answer 3

seen person-friendly for software is the way ... then you'll do the clean up through some macro it isn't see you later to study it, in spite of the undeniable fact that it calls for stamina ;-) My outstanding suggestion, study it, prepare it and also you received't experience sorry about (beeing a draw close in Excel have a outstanding variety of reward) commence immediately: attempt to record your clean up utilising the macro recorder device. Press ALT+F11 and seem on the code. Your mission is to make the code versatile adequate so as that it ought to correctly be utilized for any import sturdy success

Answer 4

what sort of manual cleanup do you need to do?



this is just a guess, but maybe most of your cleanup can be solved if you save the .xls as a .csv file...then upload.