Field Length

[fzx5v0]

Hi
I use MS access for updating and matching my product in my database with my suppliers products

the problem I have is that my supplier has a field in there spreadsheet for product description that is longer than 255 characters so ms access chops it to 255 characters.

Onece the data is processed it is then imported to mysql for the website.

Can anyone advise if there is a way around keeping all the data for the product descriptions as this is causing me a lot of work updating the product descriptions manually

thanks

 

[WIS]

Hi
I use MS access for updating and matching my product in my database with my suppliers products

the problem I have is that my supplier has a field in there spreadsheet for product description that is longer than 255 characters so ms access chops it to 255 characters.

Onece the data is processed it is then imported to mysql for the website.

Can anyone advise if there is a way around keeping all the data for the product descriptions as this is causing me a lot of work updating the product descriptions manually

thanks

Can you use a memo instead of text data type for the product description fld?

 

[fzx5v0]

Hi
Tried memo but still the same thing is happening i think the only way around it is not to use access but mysql as it seem to work fine there

thanks

 

[namliam]

You have to not only change the database but also the import specification where it is probably setup as text instead of Memo.

 

[fzx5v0]

Yes the import was set to memo but it made no difference

thanks

 

[Atomic Shrimp]

Have you checked that it's actually truncated in the raw table after importing it as a memo?

There are lots of different circumstances in which Access will truncate memos to 255 character in queries - if you're seeing the truncation in the results of a query, then it could be for one of the reasons detailed here:
http://allenbrowne.com/ser-63.html

 

[fzx5v0]

Hi yes
it is truncated in the raw table

thanks

 

[Atomic Shrimp]

Well, that's quite peculiar - are you importing it into Access or linking?

Have you tried creating an empty receiving table (with the field already defined as Memo) and importing specifically into it?