Re: FN-FORUM: excel problem

date posted 25th March 2007 10:04

I am trying to copy from MySql to Excel and I have two problems now not
one. I can't import the Excel file into Access becacasue of the "/n" at the
end of the rows. It is fine if there is just one row. Plus the "/n"'s in
some of the fields is throwing out the layout




Pam




----- Original Message -----
From: "Colin Shipton" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, March 25, 2007 9:57 AM
Subject: RE: FN-FORUM: excel problem


>
> Hi Pam
>
> I believe you can either replace the newline character (vbcrlf) with \n or
> simply enclose the text inside 's but the latter will not sort out the
> display problems in Excel.
>
> I think this is right, but a long time since I did anything like this.
>
> What sort of database are you using? If it's MS SQL you can use the
> import/export wizard to create the file, if it's mySQL you can use
> something
> like sqlyog to export the data.
>
> Regards
> Colin Shipton | Intrafusion Limited
> T. +44 (0)1592 892411
> F. +44 (0)1592 892351
> M. +44 (0)7970 677626
> E. [EMAIL REMOVED]
> W. www.intrafusion.co.uk
>
>
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
> [EMAIL REMOVED]
> Sent: 24 March 2007 20:48
> To: FN-FORUM / [EMAIL REMOVED]
> Subject: FN-FORUM: excel problem
>
>
> Hi,
> I am trying to create an excel file from a database. The problem is
> that
> some of the fields are lengtext containing new lines which is throwing out
> the layout of the excel file. How do you treat new lines in such
> circumstances?
>
>
>
>
> Thanks
> Pam
>
>
>
>
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>