For the love of God, Please help me

[AWA]

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.

[Anne Troy]

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

"AWA" <AWA@discussions.microsoft.com> wrote in message
news:48218332-6E7D-4AB7-B0C1-46EC13E26515@microsoft.com...
>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.

[Naz]

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.

[GillianHG]

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.

[E. J. Murphy]

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.

[AWA]

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" <AWA@discussions.microsoft.com> wrote in message
> news:48218332-6E7D-4AB7-B0C1-46EC13E26515@microsoft.com...
> >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.
>
>
>

[Anne Troy]

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

"AWA" <AWA@discussions.microsoft.com> wrote in message
news:DCD55B00-33D3-4F08-8E8F-BCB14AABC97B@microsoft.com...
> 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" <AWA@discussions.microsoft.com> wrote in message
>> news:48218332-6E7D-4AB7-B0C1-46EC13E26515@microsoft.com...
>> >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.
>>
>>
>>