Excel / Access Import

[Fastbike]

Hi guys,
OK, here is a weird one.

I am importing excel data into an access data base. The database is working correctly and the current excel file I am importing is importing without any errors.

Now I am having an excel file delivered via a vendor, and I am getting errors when importing the file.

The error is produce by the first cell in the worksheet (A:1). For the life of me I can't figure out why this cell is causing an error.

So, can anyone tell me the difference between cells A:1 in the two files attached?

[Ken Wright]

The link isn't working.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Fastbike" <[email protected]> wrote in
message news:[email protected]...
>
> Hi guys,
> OK, here is a weird one.
>
> I am importing excel data into an access data base. The database is
> working correctly and the current excel file I am importing is
> importing without any errors.
>
> Now I am having an excel file delivered via a vendor, and I am getting
> errors when importing the file.
>
> The error is produce by the first cell in the worksheet (A:1). For the
> life of me I can't figure out why this cell is causing an error.
>
> So, can anyone tell me the difference between cells A:1 in the two
> files attached?
>
>
> +-------------------------------------------------------------------+
> |Filename: GoodBadFiles.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4104 |
> +-------------------------------------------------------------------+
>
> --
> Fastbike
> ------------------------------------------------------------------------
> Fastbike's Profile:
> http://www.excelforum.com/member.php...o&userid=26701
> View this thread: http://www.excelforum.com/showthread...hreadid=491258
>

[Fastbike]

Well I have worked it out.

Thanks to those who looked at it.

There was a space before some of the text that caused an error when importing the file.

[David McRitchie]

Hi Fastbike,
If you want to clean up leading/trailing spaces and nonbreaking space character
that looks like a space you can use a macro to clean up material you copy
and paste from a web page and I guess from some other non Excel sources. .
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Fastbike" <[email protected]> wrote ...
> There was a space before some of the text that caused an error when
> importing the file. [from Access]

[Max]

> The link isn't working.
(It works in Excelforum <g>)

Think we have to click on this link first:
> View this thread:
http://www.excelforum.com/showthread...hreadid=491258

... and then click on the zip link in the OP's post over there
(it works that way)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

[Ken Wright]

Ahhh - Cheers Max :-)

Regards
Ken..............


"Max" <[email protected]> wrote in message
news:Oqbqc%23t%[email protected]...
>> The link isn't working.
> (It works in Excelforum <g>)
>
> Think we have to click on this link first:
>> View this thread:
> http://www.excelforum.com/showthread...hreadid=491258
>
> .. and then click on the zip link in the OP's post over there
> (it works that way)
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
>
>