PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup Erroneous Ranges Created

Reply

Erroneous Ranges Created

 
Thread Tools Rate Thread
Old 18-11-2003, 05:17 AM   #1
VLeonard
Guest
 
Posts: n/a
Default Erroneous Ranges Created


I am importing MS Access query results into Excel using
Data, Import External Data, Import Data. I select the
database and the query to import to a named range within
Excel. I am using the same process to import many
queries and have automated the entire process to pressing
a button.

The problem is that Excel creates its own named ranges
during my automated process. The named ranges created
start with the name of the database being imported
followed by a sequential number (i.e. Sales_1,
Sales_2...) If I try to delete these named ranges, the
Database Import Query is deleted and I must rebuild the
Import External Data query. Most of the queries I import
work fine, but 6 are really causing problems. Any
suggestions or knowledge would be greatly appreciated.

VLeonard

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off