Linking Crystal to EXCEL

[mike99]

I have created an Excel file with two columns. Row 1 is column labels that I have range named and the rest of the rows are filled with numbers.

I have linked this Excel file to Crystal V8 via ODBC. In Visual linking expert in Crystal when I right click the field the properties of the field are defined as "string"
with a length of 255 characters.

What am I doing wrong? How can I change the field to a number field?

Thanks

 

[SmpTraining]

A work around (until a better offer comes up) is to

1) Convert your Excel file to Access and modify the types there
2) Create a formula to convert the text to a numeric using the ToNumber function.

There may be a better solution but these should work in the meantime. Steve Phillips, Crystal Consultant

 

[BlurredVision]

Not sure if you have done this.
I have never done this, nor have I tested this... But here is my idea. Go into excel, highlight your column, right click and select format cells. Change the format of the cells from 'general' to number.

Hope this helps Brian

http://www.crystalinfo.net