T
Tony Vrolyk
I am wanting to create a custom import module that will allow a user to
mathcup field in the imported file with fields in the desitnation query.
This would run on an MDE under Access Runtime 2002.
Other posts I have read suggested just calling the built-in import qizard
but I find this too complex for simplistic users. Plus I don't want them to
accidentally import into the wrong table. And since I am importing into a
query I am not sure there is an easy way to select it with the wizard.
The other issue is that I want to provide some field matching that would
allow the users to more easily import a file that doesn't match up to an
exact standard. let's say I am importing a customer list and sometimes the
import file has the Last Name field called "LastName" or "LN" or "Last Name"
or "Last" - I would like the user to be able to indicate which field in the
destination query the source field should go to.
I have setup an import module that brings the data into a temporary table
that has the same structure as the live table allowing the user to see how
the data will import into the live table while giving them the option to
make edits or delete it entirely to retry from scratch. But that method
doesn't allow for any flexibility in the source file field names.
Any thoughts?
Tony Vrolyk
mathcup field in the imported file with fields in the desitnation query.
This would run on an MDE under Access Runtime 2002.
Other posts I have read suggested just calling the built-in import qizard
but I find this too complex for simplistic users. Plus I don't want them to
accidentally import into the wrong table. And since I am importing into a
query I am not sure there is an easy way to select it with the wizard.
The other issue is that I want to provide some field matching that would
allow the users to more easily import a file that doesn't match up to an
exact standard. let's say I am importing a customer list and sometimes the
import file has the Last Name field called "LastName" or "LN" or "Last Name"
or "Last" - I would like the user to be able to indicate which field in the
destination query the source field should go to.
I have setup an import module that brings the data into a temporary table
that has the same structure as the live table allowing the user to see how
the data will import into the live table while giving them the option to
make edits or delete it entirely to retry from scratch. But that method
doesn't allow for any flexibility in the source file field names.
Any thoughts?
Tony Vrolyk