MySQL to Access

[Fraser]

Tweet

I have a MySQl database which I am trying to get into Access to make the data entry side a bit easier.

I am exporting to CSV using phpmyadmin and then importing to Access. The only problem is that the new lines in MySQL then become odd characters in access (little squares or black vertical lines) is there any way I can covert these back to new lines?

Any help is greatly appreciated!

[ChrisM]

try dbtools (www.dbtools.com.br) - you can directly export to access.

HTH

Chris

[Fraser]

Thanks - I'll take a look.

[uklejon]

Or convert to Excell and import into access......this is what i do with al the csv feeds.......it just seems to work better!!

Carol

[ChrisM]

Originally posted by misscarolann
Or convert to Excell and import into access......this is what i do with al the csv feeds.......it just seems to work better!!

Carol

Well, if you want an easy solution!!

[Fraser]

I did try MySQL to CSV to Excel to Access yesterday but it still gave the same problem on line breaks.