Import Excel into Access Problem

[Guest]

Hello

I'm trying to import an excel spreadsheet into Access. When I do it truncates two fields at 255 characters and will not allow me to select "Memo" field type in the import wizard. I'm desperate... can anyone help!? Is the format of my excel column incorrect (I can' figure it out)

Thank yo

Daniel

 

[Mike]

I can do if for you if it's not confidential?

-----Original Message-----
Hello,

I'm trying to import an excel spreadsheet into Access.

When I do it truncates two fields at 255 characters and
will not allow me to select "Memo" field type in the
import wizard. I'm desperate... can anyone help!? Is the
format of my excel column incorrect (I can' figure it out).

 

[Ken Snell]

Assuming that you're using the Get External Data option under File menu,
this is the normal behavior for ACCESS.

Use a macro or VBA code to import the spreadsheet's data using the
TransferSpreadsheet action (macro) or DoCmd.TransferSpreadsheet method
(VBA). Both are described in Help files.

--
Ken Snell
<MS ACCESS MVP>

Hello,

I'm trying to import an excel spreadsheet into Access. When I do it

truncates two fields at 255 characters and will not allow me to select
"Memo" field type in the import wizard. I'm desperate... can anyone help!?
Is the format of my excel column incorrect (I can' figure it out).

 

[angel]

When I am importing spreadsheets, I can never really
select the field type in access.
What I often find myself doing is saving the spreadsheet
as a comman delimeted file.
You can then modified the field type when using the import
utility to import this delimited file in access.

Angel

-----Original Message-----
Hello,

I'm trying to import an excel spreadsheet into Access.

When I do it truncates two fields at 255 characters and
will not allow me to select "Memo" field type in the
import wizard. I'm desperate... can anyone help!? Is the
format of my excel column incorrect (I can' figure it out).