I am trying to import data FROM an excel file (worsheet) into another
database, but it keeps importing all the BLANK rows and columns - thousands
of them. How do I just import the data entry? PLEASE, PLEASE help me! :-/

thanks.

Clean up your worksheet, AWA. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"AWA" wrote in message
...
I am trying to import data FROM an excel file (worsheet) into another
database, but it keeps importing all the BLANK rows and columns -
thousands
of them. How do I just import the data entry? PLEASE, PLEASE help me!
:-/

thanks.

Whats the database?
Have you tried deleting all the rows and columns you do not need then saving?
Have you tried saving the Excel file as a csv format then trying?

--

_______________________
Naz,
London


"AWA" wrote:

I am trying to import data FROM an excel file (worsheet) into another
database, but it keeps importing all the BLANK rows and columns - thousands
of them. How do I just import the data entry? PLEASE, PLEASE help me! :-/

thanks.

What sort of database are you bringing it into? If it's Access, there is an
import wizard under Get External Data
--
Thanks,
GillianHG


"AWA" wrote:

I am trying to import data FROM an excel file (worsheet) into another
database, but it keeps importing all the BLANK rows and columns - thousands
of them. How do I just import the data entry? PLEASE, PLEASE help me! :-/

thanks.

Would it help to "Set Print Area"?

"AWA" wrote:

I am trying to import data FROM an excel file (worsheet) into another
database, but it keeps importing all the BLANK rows and columns - thousands
of them. How do I just import the data entry? PLEASE, PLEASE help me! :-/

thanks.

YOU so ROCK!! THANK YOU VERY MUCH!!! :-)

"Anne Troy" wrote:

Clean up your worksheet, AWA. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"AWA" wrote in message
...
I am trying to import data FROM an excel file (worsheet) into another
database, but it keeps importing all the BLANK rows and columns -
thousands
of them. How do I just import the data entry? PLEASE, PLEASE help me!
:-/

thanks.

You're welcome! So glad I could help.
************
Anne Troy
www.OfficeArticles.com

"AWA" wrote in message
...
YOU so ROCK!! THANK YOU VERY MUCH!!! :-)

"Anne Troy" wrote:

Clean up your worksheet, AWA. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"AWA" wrote in message
...
I am trying to import data FROM an excel file (worsheet) into another
database, but it keeps importing all the BLANK rows and columns -
thousands
of them. How do I just import the data entry? PLEASE, PLEASE help me!
:-/

thanks.