P
Phuff
Hi, I am looking for some quick advice on the methods I'm
investigating..
I have a portion of my program that allows a user to import address
data from either an excel sheet, acess db, or a delimited file. What I
need to do is set up their data in a specific format that we use
without needing to inform the client ahead of time. For instance we
need the full name in a column called "Name", but the customer's file
might have a Last Name column and a Full Name column. What I'm trying
out is to fill a dataset with their data, and pop up a screen that has
2 data grids(one that specifies what it should be, and one with the
actual data) and a bunch of check boxes. While the "Name" column in
the ShouldBe table is highlighted, they select a column in their data
and then click the checkbx that describes their data. For instance
name is highlighted and they click the last name column in their data
and check the last name check box and the same for first, then click
the next button. This is supposed to bind the checkbox title with the
column heads so I can concatenate them into the proper column. It is
then supposed to move the highlighted cell in the ShouldBe datagrid
down one and allow them to proceed, until at the end I have a dataset
that is in the proper format, despite its original format. I have
figured out how to create a column of combined columns with ADO using
the expression property but I'm still learning how to do the rest.
If anyone can give me any advice, tell me a better or easier way to
accomplish this and point me in a direction to learn how to do so, or
simply say you're doing it the best way, I would really appreciate
it.(sorry I'm a novice...my first job)
Thanks!
Paul Huff
investigating..
I have a portion of my program that allows a user to import address
data from either an excel sheet, acess db, or a delimited file. What I
need to do is set up their data in a specific format that we use
without needing to inform the client ahead of time. For instance we
need the full name in a column called "Name", but the customer's file
might have a Last Name column and a Full Name column. What I'm trying
out is to fill a dataset with their data, and pop up a screen that has
2 data grids(one that specifies what it should be, and one with the
actual data) and a bunch of check boxes. While the "Name" column in
the ShouldBe table is highlighted, they select a column in their data
and then click the checkbx that describes their data. For instance
name is highlighted and they click the last name column in their data
and check the last name check box and the same for first, then click
the next button. This is supposed to bind the checkbox title with the
column heads so I can concatenate them into the proper column. It is
then supposed to move the highlighted cell in the ShouldBe datagrid
down one and allow them to proceed, until at the end I have a dataset
that is in the proper format, despite its original format. I have
figured out how to create a column of combined columns with ADO using
the expression property but I'm still learning how to do the rest.
If anyone can give me any advice, tell me a better or easier way to
accomplish this and point me in a direction to learn how to do so, or
simply say you're doing it the best way, I would really appreciate
it.(sorry I'm a novice...my first job)
Thanks!
Paul Huff