Hi,
I'm connecting to an Excel spreadsheet via ODBC, trying to link it to some SQL tables. The field on which I can link to the SQL tables is "Sales Rep" which, although it is a number, is a String field.
So I altered my data in Excel to make "Text" cells which happen to contain numbers. But when I connect to it via ODBC that set of data has been read as Number again.
I saw a similar post in the archives about memo vs. text fields...Is this a Crystal thing, or an ODBC thing? I'm using CR8.5
thanks in advance for any help,
Caroline
I'm connecting to an Excel spreadsheet via ODBC, trying to link it to some SQL tables. The field on which I can link to the SQL tables is "Sales Rep" which, although it is a number, is a String field.
So I altered my data in Excel to make "Text" cells which happen to contain numbers. But when I connect to it via ODBC that set of data has been read as Number again.
I saw a similar post in the archives about memo vs. text fields...Is this a Crystal thing, or an ODBC thing? I'm using CR8.5
thanks in advance for any help,
Caroline