Crystal Reports Developer Version 14-04-0-5335

[#1]

Can any body please help me

I have a Debian Database which was created from source files being numerous .xlsx file's

The data sits in the Database fine with various fields correctly showing as being Text fields as per the screen shot below

however when i Use Crystal to navigate to this Table Crystal sees all the Text fields as Memo and therefore when i go to the Links Tab under Database Expert the Memo fields dont show

I have checked that the .xlsx files text columns are formated as Text and also the Fields are also to have a maximum of 250 Characters

Can you please advise what i can do ie how i can see Memo fields in the Link window or how to convert the Memo fields to String/Text

[DonWilliams]

How are you connecting to the XLXS files?

You can enable CR's database logging component to see what is happening:

https://userapps.support.sap.com/sap/support/knowledge/en/1603398

Look for the string length, CR is querying the Client to get the length, it's likely returning 65k or more, you'll have to go to makers to fix it.

I don't see xlxs as a data source in CR Database wizard:

So likely cause is the Excel client you are using is returning the length, likely 65K.

A quick Google search for this, see if MS's client works for you:

1. Install the Drivers [1]

• Most Windows systems require the installation of the Microsoft Access Database Engine Redistributable. This package installs the necessary 32-bit or 64-bit OLEDB and ODBC drivers for modern Office extensions (.xlsx). [1, 2, 3, 4, 5]

2. Configure the ODBC Data Source (DSN) [1]

1. Open the Windows Start menu and search for ODBC Data Sources.
2. Choose 64-bit or 32-bit to strictly match the architecture of the application reading the data.
3. Under the User DSN or System DSN tab, click Add....
4. Select Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb) and click Finish.
5. Provide a memorable Data Source Name (DSN).
6. Click Select Workbook..., navigate to your target .xlsx file, and confirm. [1, 2, 3, 4]

Don