ViolettePhan
06-29-2006, 11:01 AM
Hi all,It's me again...I need to build an import form. I have 2 list boxes, first called lstSource with the values of columns headers from an excel file (the excel file is not always have same column headers) and lstDestination with values of fieldname of a fixed table name.
lstSource lstDestination
Company AddressID
Title Company
First Name Title
MiddleInitial FirstName
Last Name MI
Address LastName
City Address
State City
ZipCode StateorProvince
PostalCode
Notes
LastModified
Now I would like the user can drag value from lstSource to lstDestination or move up and down the order of lstDestination list in order to match the column of lstSource... or what ever can map the 2 ...
lstSource lstDestination
Company -> Company
Title -> Title
First Name -> FirstName
Middle Initial -> MI
Last Name -> LastName
Address -> Address
City -> City
State -> StateorProvince
ZipCode ->PostalCode
AddressID
Notes
LastModified
then when user finish moving and hit a command Import button, it will append data from excel file to table corresponding...Please give me some advice how to do it...Thanks in advance..
.VP
lstSource lstDestination
Company AddressID
Title Company
First Name Title
MiddleInitial FirstName
Last Name MI
Address LastName
City Address
State City
ZipCode StateorProvince
PostalCode
Notes
LastModified
Now I would like the user can drag value from lstSource to lstDestination or move up and down the order of lstDestination list in order to match the column of lstSource... or what ever can map the 2 ...
lstSource lstDestination
Company -> Company
Title -> Title
First Name -> FirstName
Middle Initial -> MI
Last Name -> LastName
Address -> Address
City -> City
State -> StateorProvince
ZipCode ->PostalCode
AddressID
Notes
LastModified
then when user finish moving and hit a command Import button, it will append data from excel file to table corresponding...Please give me some advice how to do it...Thanks in advance..
.VP