importing exel data - defining data type in access fields

  • Thread starter Thread starter mitja decman
  • Start date Start date
M

mitja decman

Hi,

I have excel 2003 table with first row as field names and next row (fro now)
with data. I imported to Access 2003 fine.
I noticed that if the field in excel is a number, ie. 1, access makes a
double filed, and if it is a string, ie. "dog", access makes text data type,
255 length.
How do I define that I want Integer data type for numbers from excel and
text data type, length 10 for strings from excel?
If this is not possible at import how do I change all double fields to
integer fields, doing it manualy takes to much time (250 fields in a table).

Thanks
Mitja Deèman
 
The best way (IMHO) is to define your table in Access with the field
definitions you want. Then, when you import, instead of importing to a new
table, import to an existing table. You just need to empty the contents of
the existing table before importing new data.
 
Back
Top