importing exel data - defining data type in access fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mitja decman - 10 Aug 2005 13:40 GMT

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

Reply to this Message

Klatuu - 10 Aug 2005 14:25 GMT

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.

> Hi,
>
[quoted text clipped - 10 lines]
> Thanks
> Mitja Deèman

Reply to this Message