[mso] Excel - Access
- From: "Glenda Wells" <gwells@xxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Tue, 16 Sep 2003 12:04:14 -0400
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:
