Import Excel Datasheet in Access

[Max Gauthier]

Hi,

I need to import an excel datasheet into a MS Access 2002
database (mdb). One of the XLS colums im importing is over
255 characters but when im importing into access it
detects it as a Text Field so its capped to 255 and it
truncates the rest. I wanted to change the DataType but
the Field is disabled on the Import wizard.

I dont know why but I tried to import from an other
computer and this time it detects memo, wich is the
datatype I really want.

Is there a way to chose the default datatype or to force
it when importing a datasheet?

Best regards,
Max Gauthier

 

[Jim/Chris]

Have you tried linking to the excel spreadsheet and using
an append query into a table that's field is defined as a
"MEMO"?

Jim

 

[Guest]

eh, not yet but I know that should work fine. I read a few
articles on MS Knowledge base and there is nothing about
that MEMO problem so I guess I'll just create my table
structure and append my xls spreadsheet into it.

Thanks for answering

Max

 

[John Nurick]

Hi Max,

Access examines the first few rows of data when deciding on the field
types to use. If the first cells in your column have fewer than 255
characters, Access will assign a text field, but if there is a cell with
more than 255 characters at or near the top of the column it should
assign a memo field.