[mso] FW: Excel - Access
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 16 Sep 2003 15:45:23 -0400
-----Original Message-----
From: Glenda Wells
Sent: Tue 9/16/2003 12:04 PM
To: 'mso@xxxxxxxxxxxxx'
Cc:
Subject: Excel - Access
Hi All.
Lively discussions this week.
I get data via MS Terminal Services in Excel. The workbook consists of
several worksheets that are linked to data via MS Query. I download this file
to my local computer and would like a way to link Access tables to this data so
each time I download (i.e. refresh the data), the "new" data will be available
in Access.
I've tried doing this and there is a problem. The Excel worksheets
almost always have columns and rows with nothing in them. For example, a
worksheet that should have 408 rows of data may have 5,000 rows, most of them
empty. Or there may be 10 columns containing data and another 10 with no data.
How can I either download only rows and columns containing data in
Excel, or have Access recognize only those rows and columns containing data?
BTW, in Excel I can Shift+End to the right then down which highlights
only rows and columns containing data.
Any advice appreciated. /g
*************************************************************
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:
- » [mso] FW: Excel - Access
