Skip to Content
Former Member
May 31, 2013 at 10:52 PM

Cannot refresh report


i have a linked .xlsx input file defined via ODBC(rdo) of about 74k rows.

All text columns columns are restricted to 255 chars.

I have created a report and it works fine.

But when i try to refresh with latest data, However everytime i refresh the

report with the new data, i always get the message

"Failed to retrieve data from the database",

followed by

"Details: 22001:[Microsoft][ODBC Excel Driver] The field

is too small to accept the amount of data you attempted to add.

Try inserting or pasting less data. [Database Vendor Code: -1047]

How do i get around this issue ? different connection type ? driver ?