excel to access

[briankind]

Hello there
i have this field in excel called project desciption that is mor than 255 characters.

i wish to import the excel file to access

unfortunatley my access table only has 255 characters.

it is not letting me do it.

any suggestions.


Help

 

[GohDiamond]

Each TEXT field in Access allows 255 Characters. If you have a single field that has more than 255 chanracters Change the Access field type from Text to MEMO.

Goh

 

[EdFred]

Memo field as opposed to text.

 

[briankind]

change text to memo

i ussually do a straight import.

how can you change it doing this process.
is there another way?

Thanks

 

[briankind]

microsoft cannot save any changes to a link table.

after the import i got this message while attempting to change data atyp in data sheet view:

microsoft cannot save any changes to a link table.

is there a process i can do this ? i mean easier process
thanks

 

[briankind]

problem

change text to memo

--------------------------------------------------------------------------------

i ussually do a straight import.

how can you change it doing this process.
is there another way?

Thanks

also



microsoft cannot save any changes to a link table.

--------------------------------------------------------------------------------

after the import i got this message while attempting to change data atyp in data sheet view:

microsoft cannot save any changes to a link table.

is there a process i can do this ? i mean easier process
thanks

 

[briankind]

change text to memo

problem

--------------------------------------------------------------------------------

change text to memo

--------------------------------------------------------------------------------

i ussually do a straight import.

how can you change it doing this process.
is there another way?

Thanks

also



microsoft cannot save any changes to a link table.

--------------------------------------------------------------------------------

after the import i got this message while attempting to change data atyp in data sheet view:

microsoft cannot save any changes to a link table.

is there a process i can do this ? i mean easier process
thanks

 

[GohDiamond]

In the Design View of the Access Table that you are importing the Excel information to, change the Access Table field type to MEMO for the corresponding EXCEL Field that you wish to import. You do not make any changes in DATASHEET view of either the Access table or the Linked Excel File. It seems like you were trying to make changes to the LINKED XL file instead of importing the XL File content into the structured table in Access.

For example you have 3 Excel Headers
StuffID StuffName StuffDescription

StuffID is a simple serial number
StuffName is a Name less than 255 characters
StuffDescription is a text description which may have more thatn 255 characters depending on the item and depending on the person who is verbosely entering details of the characteristics of said item such that it resembles the chapters of a book on the rise and fall of the third version of said item ad nauseum... you see what I mean.

In Access your Table design would be something like this:
StuffID TYPE= Text (primary Key)
StuffName TYPE = Text
StuffDescription TYPE = MEMO

When the Excel file is imported make sure the wizard knows which fields are being imported to which Access Fields

You shouldn't get any conflicts, but nothing is 100% guaranteed

Goh

 

[briankind]

answered the question

you have answered the question

 

[briankind]

bigger problem with the /in the query i have used the group by function / problem is

Hello
i have changed the to memo
and have brought in the data.

how ever the problem is that it still cuts the value of characters after a query is returned.
in the query i have used the group by function

so instead of 1800 it is around 1200

 

[neileg]

Access will truncate memo fields in queries that involve processing the data like aggregate queries (group by). If possible, create your query without the memo field and then join your query results with the memo field(s).