Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database fields get cut off in Excel
Hi,
I've set up a simple query to a Sybase database (select * from tablename) where some of the fields contain text strings. No matter what I've tried (not that I'm an expert in Excel), the text is cut off after a few characters in a seemingly random way (in some cases, I get 5 characters and in others 14). Anybody know how to fix this? Any help is much appreciated, Ann Rossi, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database fields get cut off in Excel
I've never used Sybase. Some clues:
1. Excel truncates cell contents after 255 characters. 2. If your query determines a column to be numeric (scanning n rows only) and then finds that some rows have characters, those rows are lost. You might consider researching SCHEMA.INI on Google. "Ann Rossi" wrote: Hi, I've set up a simple query to a Sybase database (select * from tablename) where some of the fields contain text strings. No matter what I've tried (not that I'm an expert in Excel), the text is cut off after a few characters in a seemingly random way (in some cases, I get 5 characters and in others 14). Anybody know how to fix this? Any help is much appreciated, Ann Rossi, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database fields get cut off in Excel
You don't say how you're running your query but if you're not using
ADO you might consider switching to that. See the example below: you will have to adjust the connection string to connect to a sybase db. Second link has connection string examples. http://groups.google.com/groups?hl=e...%3D10%26sa%3DN http://www.able-consulting.com/MDAC/...riverForSybase If you're already using ADO then you might consider posting the actual code you're using. Tim. "Ann Rossi" wrote in message om... Thanks for your message, but the strings aren't that long. I have one column consisting of a bunch of rows with the word "unknown". It's neither a number nor anywhere near 256 characters and it's displayed as "unk". BTW I'm using Excel 2000 if that makes any difference. Thanks, Ann Rossi, "AA2e72E" wrote in message ... I've never used Sybase. Some clues: 1. Excel truncates cell contents after 255 characters. 2. If your query determines a column to be numeric (scanning n rows only) and then finds that some rows have characters, those rows are lost. You might consider researching SCHEMA.INI on Google. "Ann Rossi" wrote: Hi, I've set up a simple query to a Sybase database (select * from tablename) where some of the fields contain text strings. No matter what I've tried (not that I'm an expert in Excel), the text is cut off after a few characters in a seemingly random way (in some cases, I get 5 characters and in others 14). Anybody know how to fix this? Any help is much appreciated, Ann Rossi, |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database fields get cut off in Excel
"AA2e72E" wrote ...
I've never used Sybase. If your query determines a column to be numeric (scanning n rows only) and then finds that some rows have characters, those rows are lost. You might consider researching SCHEMA.INI on Google. I think you may have mistaken Sybase for a text file. Jamie. -- |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database fields get cut off in Excel
I'm faily new at using Excel, so bear with the stupid questions:
What's ADO? And what do you mean by code? I just used the MS Query wizard to set up the query and the connection to the database. I've been playing around with this some more and discovered that a) this works with Excel 97 (no fields are cut off) and b) the result of the query is displayed correctly in the MS query window. Ann Rossi. "Tim Williams" <saxifrax@pacbell*dot*net wrote in message ... You don't say how you're running your query but if you're not using ADO you might consider switching to that. See the example below: you will have to adjust the connection string to connect to a sybase db. Second link has connection string examples. http://groups.google.com/groups?hl=e...%3D10%26sa%3DN http://www.able-consulting.com/MDAC/...riverForSybase If you're already using ADO then you might consider posting the actual code you're using. Tim. "Ann Rossi" wrote in message om... Thanks for your message, but the strings aren't that long. I have one column consisting of a bunch of rows with the word "unknown". It's neither a number nor anywhere near 256 characters and it's displayed as "unk". BTW I'm using Excel 2000 if that makes any difference. Thanks, Ann Rossi, "AA2e72E" wrote in message ... I've never used Sybase. Some clues: 1. Excel truncates cell contents after 255 characters. 2. If your query determines a column to be numeric (scanning n rows only) and then finds that some rows have characters, those rows are lost. You might consider researching SCHEMA.INI on Google. "Ann Rossi" wrote: Hi, I've set up a simple query to a Sybase database (select * from tablename) where some of the fields contain text strings. No matter what I've tried (not that I'm an expert in Excel), the text is cut off after a few characters in a seemingly random way (in some cases, I get 5 characters and in others 14). Anybody know how to fix this? Any help is much appreciated, Ann Rossi, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List the UNIQUE certain fields from the database | Excel Worksheet Functions | |||
Database fields in Excel? | New Users to Excel | |||
Query of an Access database won't let me get more than 95 fields. | Excel Discussion (Misc queries) | |||
import specific fields only from excel to database | Excel Discussion (Misc queries) | |||
How do I create a template that add the fields to a database? | Excel Discussion (Misc queries) |