Access Import

J

John Vinson

I would like to import a mysql file (.sql) into access.
Is this possible?
Click to expand...

Yes; you need to get the "ODBC Driver" software from the MySQL
website. It comes with instructions.
 
G

Guest

John, Thanks for the quick response! I installed the ODBC
driver from mysql but I when I try to open a .sql file
into Access ,I still get the error message -
"unrecognized database format (error 3343)". BTW I do
have the MSSQL Server Service Manager installed.

Arlen Field
 
J

John Vinson

John, Thanks for the quick response! I installed the ODBC
driver from mysql but I when I try to open a .sql file
into Access ,I still get the error message -
"unrecognized database format (error 3343)". BTW I do
have the MSSQL Server Service Manager installed.
Click to expand...

You can't open it directly, IIRC. Instead, open Access and use File...
Get External Data... Link; select ODBC from the "files of type"
dropdown, and select your ODBC connection.
 
F

fafield

John, Hate to be a pest but I'm still having trouble - as
follows:
1.I open a blank data base and go to Get External Link.
2.I get the ODBC Driver window and input my user name.
3. I press the Test data button and get an
encouraging "connected successfuly to SQL file".
4. I press OK and then get an ACCESS error window with
the message - "Reserved Error (-7778)!?

Any suggestions?

TIA, Arlen Field
 
J

John Vinson

John, Hate to be a pest but I'm still having trouble - as
follows:
1.I open a blank data base and go to Get External Link.
2.I get the ODBC Driver window and input my user name.
3. I press the Test data button and get an
encouraging "connected successfuly to SQL file".
4. I press OK and then get an ACCESS error window with
the message - "Reserved Error (-7778)!?
Click to expand...

Wish I could help more but no suggestions jump to mind!

Perhaps a repost - here or crossposted in
microsoft.public.access.externaldata (put both newsgroups on the
Newsgroups line, don't multipost) with a subject line mentioning "ODBC
MySQL" would get this to the attention of someone with more direct
experience with this problem.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

export text record separator 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Importing Text Files Into Access 1
Access for MySQL data reports only 5
How to export table from outlook into ms access table? 0
ODBC not working 2
Exporting and Zipping Files with Access VBA 4
programming with Access 2007? 15

Top