Managing Product Descriptions (lots of text)

[milkman2500]

Hi,

I have a database with over 30,000 products. Each product has a description that is roughly a paragraph. I'm hesitating to upload the product descriptions into the database, as I'm concerned it will inflate the size of the database and slow it down.

Does anyone have suggestions on how they manage this? Should I keep the product descriptions outside the database (in excel) and establish a linked table?

Thanks.

 

[jdraw]

Is there a short description of the product? How big is your typical paragraph -- text is restricted to 255 chars. If your data is bigger, you may need to use Memo field.

 

[plog]

Should I keep the product descriptions outside the database (in excel) and establish a linked table?

My legs must weigh a good 25 pounds each, I can cut them off, replace them with carbon fiber and save a good 40 pounds of body weight.

Think about what you are saying. You don't trust a database to efficiently manage data, so you are going to hack together a work around using Excel?

Memo field.

 

[milkman2500]

I'm under the assumption that there is a limit to the amount of text you should upload into an Access database. When I try to upload the information from an excel spreadsheet into the access table, I get an error message:

"The search key was not found in any record"

"An error occurred trying to import...The file was not imported."

 

[milkman2500]

Problem solved.

I used =Trim() in excel to remove excess spaces, then copy/pasted special as values only. Upload worked after that.

Thanks anyways!