Importing from excel issue with upgrade to office 2007

  • Thread starter Thread starter Liz Lamach
  • Start date Start date
L

Liz Lamach

I wrote a DB in Access 2000. I import from an excel file and overwrite the
table each time (as table drives query and reports). All my field data types
remained as set in original table (Dates, text and numbers).

Upgraded to 2007 and now excel files upon import are changing my master data
type in original table from number (standard, 0 decimal places) to text. Now
in report instead of a number 123,456 I get 123456.789

I am having to reformat the field data types in the table upon import
eveytime now. This is a problem as I don't do the import or run the report
for printing. So now we have an extra layer (me) to get the report printed
correctly.

I beleive the problem on the upgrade is that the data types are being
assumed now and they were not before upon overwrite. I think I need to
append (so formatting on the table is not affected). Probelm is, I don't
want any of the old data and some of it may be the same or similar. Can this
be automated so it can be done by someone unfamiliar with tables and
databases (they can import and open the report). P.S. I am a database
amateur. So please do not get too fancy.

Please help!
 
Liz said:
I beleive the problem on the upgrade is that the data types are being
assumed now and they were not before upon overwrite. I think I need to
append (so formatting on the table is not affected). Probelm is, I don't
want any of the old data and some of it may be the same or similar. Can this
be automated so it can be done by someone unfamiliar with tables and
databases (they can import and open the report). P.S. I am a database
amateur. So please do not get too fancy.
Click to expand...

Empty the Access table before importing from Excel. Then you can use
your append approach (which will preserve your table's field data types
as you have them set now).
 
Back
Top