CSV importing problems

[David Shorthouse]

Hi can any anyone help.

I have a CSV file which has been exported from filemaker pro4.

After exporting the file was fine I opened up excel & that actually removed
text from some of the fields. So I imported the CSV into access.

After the import I am getting the Carrige returns appearing as squares & the
only way I have been able to remove them is open the csv in word &
find&replace the carrige returns with a space.

here is an example
Product code - 120973,
Weblevel - The Big Catalogue - Bulk Buyers Products|power
tools,
Product_Short_D isc - JCB Rotary Mower JCB-EM33-1000,
Product Long Disc - Rotary Mower.Features include:- 1000 W.- 33cm.,
Weight - ,
Price - 7999

120973,The Big Catalogue - Bulk Buyers Products|power tools,JCB Rotary Mower
JCB-EM33-1000,Rotary Mower.Features include:- 1000 W.- 33cm.,,7999

What id like to do is create my access database click a button which will
remove the squares & replace with carrige returns then link directly into
the access database I want to update.

Any components I'd need to use.. I am using VB 6 enterprise edition at work
so.....

Many thanks

Dave

Dave

[Geoff Turner]

Re: CSV importing problems

What format did you export the file in?
You may have used tab delimited, try using comma delimited fields. This
produces
a file like "texte1","text2 ",number1, "text3",number3 ,...
It will also append a CR / LF for a new line.

I have used this format many times to export/import from Excel/Access so
that
VB programs can import/export data.

HTH
Geoff Turner
----------------------------------------------------------------------------
---------------
"David Shorthouse" <abuse@globalne t.co.uk> wrote in message
news:e7idnYMwAK cz8t3dRVn-tA@brightview.c om...[color=blue]
> Hi can any anyone help.
>
> I have a CSV file which has been exported from filemaker pro4.
>
> After exporting the file was fine I opened up excel & that actually[/color]
removed[color=blue]
> text from some of the fields. So I imported the CSV into access.
>
> After the import I am getting the Carrige returns appearing as squares &[/color]
the[color=blue]
> only way I have been able to remove them is open the csv in word &
> find&replace the carrige returns with a space.
>
> here is an example
> Product code - 120973,
> Weblevel - The Big Catalogue - Bulk Buyers Products|power
> tools,
> Product_Short_D isc - JCB Rotary Mower JCB-EM33-1000,
> Product Long Disc - Rotary Mower. Features include: - 1000 W. - 33cm. ,
> Weight - ,
> Price - 7999
>
> 120973,The Big Catalogue - Bulk Buyers Products|power tools,JCB Rotary[/color]
Mower[color=blue]
> JCB-EM33-1000,Rotary Mower. Features include: - 1000 W. - 33cm. ,,7999
>
> What id like to do is create my access database click a button which will
> remove the squares & replace with carrige returns then link directly into
> the access database I want to update.
>
> Any components I'd need to use.. I am using VB 6 enterprise edition at[/color]
work[color=blue]
> so.....
>
> Many thanks
>
> Dave
>
> Dave
>
>[/color]