in reply to Regular Expression help, MS Access Pipe delimited export gone bad
|Mice Skating|EACH|$1.50|$0.75|MC1.JPG
it looks like you are not using a text qualifier( double quotes for example ) when you export your table(s). mysqlimport will know what to do with the exported file if you do( at least, that has been my experience ). this is not a perl solution, but it may help you your stated problem: I was given an Access database which I am trying to get into MySQL.
Will perl for money
JJ Knitis
(901) 756-7693
gt8073a@industrialmusic.com
|
|---|
In Section
Seekers of Perl Wisdom