Solved

Export Access to EXCEL problem

Posted on 2014-03-21
3
248 Views
Last Modified: 2014-05-14
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
0
Comment
Question by:nickmark
  • 2
3 Comments
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39945048
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
 

Author Comment

by:nickmark
ID: 39945091
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
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39945158
I would try with a new worksheet.

/gustav
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now