4
Contributors
5
Replies
6
Views
7 Years
Discussion Span
Last Post by appnub
0

Hello,

several options.

1. Export to excel then save as a .CSV file and import to MySQL.

2. Find a copy with the hack of Access2MySQLSync and it will do the work for you.

3. export to a tab delimited file and import.

0

Navicat, which is a GUI for MySQL and can be downloaded and used for free for 30 days, has an import from MS Access built in. I did this several months ago. Works fine.

Also as rch mentioned, export to a delimited text file and then import through your phpAdmin

0

I tried with excel & tab delemanated. But it shows

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Item	Quantity 3.B	3 3.B	20 3.A	50' at line 1
Item Quantity3.B33.B203.A50

I have attached two sample files bill.xls & bill.txt. Im using Excel 2010.
Please help me. and thanks for reply

Attachments
0

MOst ppl here wont download a file posted by someone. Seriously, go to navicat.com, download the free trial version, then you can inport an access file directly into MySQL database. Its that easy.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.