Forum Moderators: phranque
My apologies if this is being posted in the wrong forum, I really wasn't sure where it would belong!
I am using a program that extracts data from excel 2002 and places it into a static webpage. The only problem is that when it extracts it, it only takes the first 256 characters, even though the excel sheet has many more. Does anyone have any advice as to what I should do? I researched a bit and was able to find out information about the field being "memo" rather than "text", but was not able to find out how to switch this. With the program, I am able to make queries to the database.
Thank you for your help!
Matt
Only workaround I know is to export the data as CSV or something similar and then import the raw files directly.
You won't have this issue if you use Access instead.
In my case, the problem was with the email program, not with Excel.
It's an issue with the ODBC driver, has been for a loooong time.
When you link an Excel spreadsheet to an Access database, and the columns of the Excel spreadsheet contain more than 255 characters, the columns are mapped to Memo data types, and the Format property of the Memo field is set to @. Therefore, Access treats the Memo field as a text field, and you can view only 255 characters of data.
However, when you import an Excel spreadsheet that has columns that contain more than 255 characters, the columns are mapped to a Memo field with no specific format. Therefore, you can view the complete data in the field.
The problem is in the way Access formats the data, not in Excel.
The problem is in the way Access formats the data, not in Excel.
OK, that wasn't what I said at all - I said I had the 255 character clipping trying to import data FROM Excel to other apps, but don't have that problem importing from ACCESS. If you need to build a table for importing and you have text > 255 characaters the use ACCESS instead of EXCEL if you have it.
I have since been using access and everything has been working fine.
I really appreciate your thoughts and help. I can't tell you how relieved I was when this finally worked for me (It has been a multi-step process, with problems every step of the way!).
Matt
