On 2/22/06, sheeri kritzer <[EMAIL PROTECTED]> wrote: > A batch script or shell script can easily be written to do this. > > -Sheeri > > On 2/20/06, Daniel Kasak <[EMAIL PROTECTED]> wrote: > > I've got some import scripts that are giving me trouble. > > > > Some MOFOs keep changing the format of the data they give us, and > > sometimes I loose half the records. When this happens, I change the line > > terminator from \r\n to \n ... or from \n to \r\n. > > > > It's starting to get to me. Is there any way to ease my pain here, short > > of importing with one format, counting the number of records, truncating > > the table, importing wit the other format, counting the number of > > records, and then selecting the format with the most number of records? > > > > -- > > Daniel Kasak > > IT Developer > > NUS Consulting Group > > Level 5, 77 Pacific Highway > > North Sydney, NSW, Australia 2060 > > T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 > > email: [EMAIL PROTECTED] > > website: http://www.nusconsulting.com.au > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
I would stick with the VBA solution, heh, if you use it you can even "call" Word and use "save as", in fact "converting" your document to plain ol' windows text file... Then I guess you can go back to Access and just let it roll... -- Daniel da Veiga Computer Operator - RS - Brazil -----BEGIN GEEK CODE BLOCK----- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ ------END GEEK CODE BLOCK------ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
