Is there a GUI control I can use in VBA to map elements of one list to elements of another list?
I'm writing an application to import a file into MS Access. The application will have a target table already defined, and needs a way to map the columns of spreadsheet/CSV to the columns in the table. I want to do this using a GUI control which shows the table column names listed on the left, the names of the fields from the source file, and some means of matching them up ... ideally a line drawn between elements on the left to elements on the right.
If drawing lines is asking too much, then the control for Map Custom Fields in Outlook for Contact Import would be a usable alternative.
Where might I find such a control?
If drawing lines is asking too much, then the control for Map Custom Fields in Outlook for Contact Import would be a usable alternative.
Where might I find such a control?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Dale Fye
If you are going to have to do this on a regular basis, I would recommend storing these mappings in your own Import Specifications set of tables, so you can select the import specification and it would identify the destination table and field mappings. Then you could check to see whether the source fields exist in the spreasheet you have elected to import and if not, use conditional formatting in the 3rd table to indicate so.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<off topic> Sorry about my duplication of your suggestion, guys. My internet is very slooooow today, and this post (which I sent off about a hour ago) just now showed up!
@Scott
I think the EE servers are slow today. Responses from some of my clicks take a long time, as do page loads.
I think the EE servers are slow today. Responses from some of my clicks take a long time, as do page loads.
LOL.
I thought the problem with latency was that I'm using LogMeIn to log onto my home computer, and then accessing the internet from home.
Now that I've switched over to accessing directly from my laptop via wifi, it is still slow.
I thought the problem with latency was that I'm using LogMeIn to log onto my home computer, and then accessing the internet from home.
Now that I've switched over to accessing directly from my laptop via wifi, it is still slow.
Curious why you awarded a B grade without even responding to any of the Expert comments.