T
Tom
I have several diferent sources of data incuding Excel spreadsheets and other
non access databases that I will be importing into an access 2007 database.
The issue is that part numbers are not uniform. Some have dashes in the part
numbers and others do. I am looking at the easiest way to import the data and
then once it is imported to make sure the required dashes are added to the
data.
Any suggestions? I thought of using an input mask on the field and then
importing or appending to that table but that didn't work. Can I use an
update query to apply the correct format to the imported data? How do you
apply an input mask to data store in a table?
Any sugestions aremuch appreciated
Thanks
non access databases that I will be importing into an access 2007 database.
The issue is that part numbers are not uniform. Some have dashes in the part
numbers and others do. I am looking at the easiest way to import the data and
then once it is imported to make sure the required dashes are added to the
data.
Any suggestions? I thought of using an input mask on the field and then
importing or appending to that table but that didn't work. Can I use an
update query to apply the correct format to the imported data? How do you
apply an input mask to data store in a table?
Any sugestions aremuch appreciated
Thanks