By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,471 Members | 722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,471 IT Pros & Developers. It's quick & easy.

Importing Excel to Access

P: n/a
Hi All,

I am sent an excel spreadsheet on a daily basis. Sometimes it contains 10
rows; sometimes it contains over 5000 rows. I copy this spreadsheet into
another spreadsheet and verify the format of the data (some data is missing,
which I can add, some 15 digit data needs to be text rather than numeric,
sometimes the incoming numbers are not consistent and need leading digits,
etc.). I then import this data (from the second spreadsheet) into Access.
Frequently as I do this I get a lot of empty rows. Is there a way in Excel,
or Access to limit what is being imported. I'm not using VBA to do the
import.

I seem to remember something in excel which would do this, but it's been too
long since I've used it. I've tried looking in the help and in some manuals
but can't seem to find it.

Another scenario with the same principle. Suppose I had a spreadsheet with
100 rows, but I only want to import rows 25 - 75 into Access. How could I
do this?

Any suggestions would be greatly appreciated.

Thanks,

Don Reynolds

__________________________________________________ _____________________________
Posted Via Uncensored-News.Com - Accounts Starting At $6.95 - http://www.uncensored-news.com
<><><><><><><> The Worlds Uncensored News Source <><><><><><><><>

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Your issue is in the Excel universe. Post your question there for best
results.

If you have marshalled your data into the upper left of the spreadsheet with
no empty rows, I believe you can delete all of the columns and rows beyond
your data.

HTH
--
-Larry-
--

"Don W. Reynolds" <dr**************@earthlink.net> wrote in message
news:40**********@cosmos.uncensored-news.com...
Hi All,

I am sent an excel spreadsheet on a daily basis. Sometimes it contains 10
rows; sometimes it contains over 5000 rows. I copy this spreadsheet into
another spreadsheet and verify the format of the data (some data is missing, which I can add, some 15 digit data needs to be text rather than numeric,
sometimes the incoming numbers are not consistent and need leading digits,
etc.). I then import this data (from the second spreadsheet) into Access.
Frequently as I do this I get a lot of empty rows. Is there a way in Excel, or Access to limit what is being imported. I'm not using VBA to do the
import.

I seem to remember something in excel which would do this, but it's been too long since I've used it. I've tried looking in the help and in some manuals but can't seem to find it.

Another scenario with the same principle. Suppose I had a spreadsheet with 100 rows, but I only want to import rows 25 - 75 into Access. How could I
do this?

Any suggestions would be greatly appreciated.

Thanks,

Don Reynolds

__________________________________________________ __________________________
___ Posted Via Uncensored-News.Com - Accounts Starting At $6.95 - http://www.uncensored-news.com <><><><><><><> The Worlds Uncensored News Source <><><><><><><><>

Nov 13 '05 #2

P: n/a
Delete all data except the title row and the data you want, name the range
of cells you want to import and choose the named range when importing. When
asked click on "First row contains titles"
I do this on a regular basis and it works in Access 2000.

Ray

"Don W. Reynolds" <dr**************@earthlink.net> wrote in message
news:40**********@cosmos.uncensored-news.com...
Hi All,

I am sent an excel spreadsheet on a daily basis. Sometimes it contains 10
rows; sometimes it contains over 5000 rows. I copy this spreadsheet into
another spreadsheet and verify the format of the data (some data is missing, which I can add, some 15 digit data needs to be text rather than numeric,
sometimes the incoming numbers are not consistent and need leading digits,
etc.). I then import this data (from the second spreadsheet) into Access.
Frequently as I do this I get a lot of empty rows. Is there a way in Excel, or Access to limit what is being imported. I'm not using VBA to do the
import.

I seem to remember something in excel which would do this, but it's been too long since I've used it. I've tried looking in the help and in some manuals but can't seem to find it.

Another scenario with the same principle. Suppose I had a spreadsheet with 100 rows, but I only want to import rows 25 - 75 into Access. How could I
do this?

Any suggestions would be greatly appreciated.

Thanks,

Don Reynolds

__________________________________________________ __________________________
___ Posted Via Uncensored-News.Com - Accounts Starting At $6.95 - http://www.uncensored-news.com <><><><><><><> The Worlds Uncensored News Source <><><><><><><><>

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.