I have a database that is being update and moved to another. In the process the data types are being redefined.
There are some examples of cirumstances where data that WAS a string is now going to be a number.
Im exporting the data out of one db via access linked tables into a spreadsheet.
(this part works fine)
Im editing the spreadsheet.
(this is the part I need help with)
and importing back into access via linked tables to ANOTHER db
(This part works fine.)
Assume I have a list of product codes, and standard weights for products and other data.
the old system stores weight as a string, and the strings look like "0068.00" (as an example)
how do tell access that these exports are really numbers without the leading zeros. Ive tried various number format commands while all cells (but the label) are connected, but so far I havent found the right stuff.
Any ideas?
PS Excel 2007 is the version
Start Free Trial
