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_Disc - 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]

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" <ab***@globalnet.co.uk> wrote in message
news:e7********************@brightview.com...

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_Disc - 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