Getting "Cannot perform runtime binding on a null reference" but....

Trying to extract an Access View to an Excel file for backup/archival purposes. I'm using v 4.3.5 (32bit).
Getting the error message as per my subject line but I can output the data if I view and save the output file from the preview.
Not sure what's going on here. Anyone one help ?

Hi Ken,

Your screenshot looks a bit strange to me  On READ is just one record and you export 12,953 rows to Excel?

Are you able to export the VIEW to a CSV file via the TextFile Adapter ?

Would it be possible to share your FlowHeater definition for more analysis?
 

Good morning Robert
My apologies - that screenshot is misleading as it shows the previous Test Run output result but then I ran the definition for real and it only reads 1 record but leaves the Test Result write count  on the display.
If I click on Show File from the Test Run I get a usable Excel file which I can save.
Below is the real run screenshot


If I convert the FHD to write via a TextFile adapter and save as CSV output it runs with no errors and a lot faster too. A few seconds rather than 20 minutes or so for the Excel version,
Hope the attached FHD and this conversation helps.

Kind regards
Ken

Hi Ken,

I guess in your VIEW are some NULL/DBNULL values available for the “Job_ID” field?

Please try to enable 1) “Override if file already exists” and disable 2) “Update data” in the Excel Adapter Configurator, see screenshot below.

 

I tried your suggestion but it still fails.
I'm happy to zip up the database if you need to see it. I can't see anything wrong with the JobDets view I'm using. The base Job table has one record with a Job_Id value of zero and I've tried to filter that out just in case but it still fails to output..

I've attached the FH Log just in case.

The CSV works but needs refinement because some of the fields will have punctuation marks etc which ruin CSV output and make extra fields in the output which is what I don't want.
That's why I'd prefer to output direct to Excel.

Hi Ken,

I tried to export NULL values to an Excel Worksheet, works fine here. To share with me the used Access database would be helpful.

For your CSV export you just have to use “Quotation marks”, see screenshot below.

 

Database zipped but can't attach as it's too big.

I tweaked the CSV output to use delimiters and it seems ok.

Hi Ken,

I found the issue. You just must add a file extension (.xlsx) for your exported Excel Workbook.

Currently I´m a bit surprised why this happened. This will be fixed within the next version.

Well I'm glad we got there in the end. Works now .
How about appending .xlsx by default if the extension is not entered or it might be safer to use .xls for people using older versions of Excel.
Many thanks for all your input.

Hi Ken,

I prefer .xlsx in case no Excel file extension is added. I guess a fixed BETA version will be available beginning of next week.