[mso] Excel Named Range
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 20 Oct 2003 11:57:20 -0400
Hi All.
I get a large Excel Workbook containing about 20 worksheets.
I import each worksheet to an Access table.
My first question about this is can I link the Access table to a named
worksheet range? I think the answer here is yes which leads to my next
question.
How can I make sure the named range includes only rows and columns that
have data in them without having to reapply the name every time?
Here's the problem. The Excel Workbook is actually linked to a database
using Microsoft Query. When I refresh the data, it looks great with
each column and row of each worksheet containing data.
When I try to link an Access table to one of the worksheets, I almost
always get excess rows and columns not containing data....that is, empty
columns and rows. For example, a worksheet containing 40 rows and 10
columns in Excel will end up with 702 rows and 23 columns when linked in
Access.
My work around to this is to copy only valid rows and columns of each
worksheet in the workbook to it's own worksheet then import that
worksheet to an existing Access table. This means I have to open the
master workbook, highlight valid rows and columns, open the
corresponding stand alone worksheet and clear it out then copy the valid
rows and columns from the master. Then, open Access and empty the
corresponding table then import the "new" table.
This is time consuming and I'm looking for a better, more efficient
method. Ideally, I think, I'd just like to link the Access tables to
the refreshed ranges in the master workbook and be done with it and I
would if it weren't for those mysterious empty rows and columns.
Any advice or suggestions appreciated.
/g
ps, this is being done in Office XP
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
