Export Access to EXCEL problem

I have an ACCESS database that exports 4 queries to EXCEL. I delete the worksheets before each export. This has been in use for about 6 months.
The size of one of the queries increased from 95 rows to 101 rows (14 columns).
That one export fails.
The others still work

The worksheet does not get deleted anymore. Consequently the export creates a new sheet with the name (NAME1).

I initially got the error message 3434Cannot exceed named range. I was not exporting to a range but when I went into the EXCEL Formula-Name Manager I fould a range for each of my worksheets. I also tried deleting the Range Name when I export and although the name was deleted, my export still did not work.

Any suggestions will be greatly appreciated.

Thankss
nickmarkAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
I would try with a new worksheet.

/gustav
0
 
Gustav BrockCIOCommented:
You can import or link a Named Range but you cannot export to it:
A string expression that's a valid range of cells or the name of a range in the spreadsheet. This argument applies only to importing. Leave this argument blank to import the entire spreadsheet. When you export to a spreadsheet, you must leave this argument blank. If you enter a range, the export will fail.
/gustav
0
 
nickmarkAuthor Commented:
Thanks so much Gustav. I did not do a good job with my original post.

I am not exporting to a range, I am exporting a query to a worksheet. I do not use ranges at all but if I go to the "Formula tab" - "Name Manager" it lists each of my worksheets from A1 to the last row/column.

I tried to delete the Named Range and the delete worked but the export still failed.

This problem began when I increased the size of the export by a few rows.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.