Dumb question - can you convert a SQL database to access? - GoFuckYourself.com

Snake Doctor · 06-03-2005, 01:07 PM

Your help is appreciated

LittleSassy · 06-03-2005, 01:10 PM

i think so...why?

Snake Doctor · 06-03-2005, 01:31 PM

Quote:

Originally Posted by LittleSassy

i think so...why?

Because I have a SQL database that I'd like to convert to an Access database

NaughtyRob · 06-03-2005, 01:33 PM

Another dumb question, why would you want to? Access is soooo limited.

psili · 06-03-2005, 01:37 PM

I know it's not like saving a JPG as a GIF, if that's what you're asking.

j/k

Can't you just dump the data from one and import it into another - tab delim, csv....?

Meorazhar · 06-03-2005, 11:27 PM

Hi Lenny,
If you're talking about importing tables from SQL database into Ms Access, here is the simpliest way to do it.

Obtain an ODBC driver for your SQL database, install it then import the tables into Access using that driver.

It worked very well for me with MySQL

Good luck.

WarChild · 06-03-2005, 11:28 PM

Quote:

Originally Posted by Meorazhar

Hi Lenny,
If you're talking about importing tables from SQL database into Ms Access, here is the simpliest way to do it.

Obtain an ODBC driver for your SQL database, install it then import the tables into Access using that driver.

It worked very well for me with MySQL

Good luck.

Antonio · 06-04-2005, 12:13 AM

SQL is a query language, you talking about MySQL?

prime · 06-04-2005, 08:01 AM

install a Mysql to Access engine/plugin
then from Access you can now import it

Sams_gfy · 06-04-2005, 08:13 AM

Export to .cvs and import into access

Snake Doctor · 06-04-2005, 08:14 AM

Quote:

Originally Posted by ContentProducer

Another dumb question, why would you want to? Access is soooo limited.

Because I can have an Access database on my local machine, but I can't have a SQL or MySQL database on my desktop.

We're doing all of our cross referencing and indexing for 2257 compliance on a SQL database on my server..then we export it to a .csv file to keep locally.
I just thought it might be better to export it as an Access database so we could run queries and stuff like that locally.

Crypt · 06-04-2005, 08:35 AM

Download Navicat MYSQL. Its a remote MYSQL software for windows.
Just need to enter your unix server ip, user/pass for mysql.

You can export,import over 50 extentions direct in your MYSQL database
with 1 click.

Access, Dbase, XLS, XML, etc etc

I use this on a daily basis.

Hope it help.

Machete_ · 06-04-2005, 08:45 AM

[QUOTE=Crypt]Download Navicat MYSQL. Its a remote MYSQL software for windows.
QUOTE]

what he said

MandyBlake · 06-04-2005, 09:00 AM

good luck lenny!

MaDalton · 06-04-2005, 09:40 AM

Quote:

Originally Posted by Lenny2

Because I can have an Access database on my local machine, but I can't have a SQL or MySQL database on my desktop.

We're doing all of our cross referencing and indexing for 2257 compliance on a SQL database on my server..then we export it to a .csv file to keep locally.
I just thought it might be better to export it as an Access database so we could run queries and stuff like that locally.

why can't you have MySQL on your local computer? of course you can have MySQL on a Windows machine - no prob at all. i must admit that Access is easier to handle when you are used to it - but for the rest....

NaughtyRob · 06-04-2005, 09:47 AM

Quote:

Originally Posted by MaDalton

why can't you have MySQL on your local computer? of course you can have MySQL on a Windows machine - no prob at all. i must admit that Access is easier to handle when you are used to it - but for the rest....

Yes, you can run Apache and MySQL locally.

06-03-2005, 01:07 PM	#1
Snake Doctor I'm Lenny2 Bitch Join Date: Mar 2001 Location: On top of my soapbox Posts: 13,449	Dumb question - can you convert a SQL database to access? Your help is appreciated __________________ sig too big

06-03-2005, 01:10 PM	#2
LittleSassy Confirmed User Join Date: May 2005 Location: behind you Posts: 7,402	i think so...why? __________________ Proadultoutsourcing.com ~ version 2.0 OFFSHORE SOLUTIONS PROVIDER SINCE 2003 ACCOUNT EXECUTIVE 264-580-554

06-03-2005, 01:33 PM	#4
NaughtyRob Two fresh affiliate progs Industry Role: Join Date: Nov 2004 Location: Inside teen pussy Posts: 29,602	Another dumb question, why would you want to? Access is soooo limited. __________________ [email protected] Skype: 17026955414 Vacares Web Hosting - Protect Your Ass with Included Daily Backups

06-03-2005, 01:37 PM	#5
psili Confirmed User Join Date: Apr 2003 Location: Loveland, CO Posts: 5,526	I know it's not like saving a JPG as a GIF, if that's what you're asking. j/k Can't you just dump the data from one and import it into another - tab delim, csv....? __________________ Your post count means nothing.

06-04-2005, 08:01 AM	#9
prime Confirmed User Join Date: Feb 2005 Location: Manila Posts: 400	install a Mysql to Access engine/plugin then from Access you can now import it __________________ \| offshore solutions \| manual labor \| staff leasing \| and more! Dedicated -Motivated-Managed Employees icq.: 309570461 live chat

06-03-2005, 11:27 PM	#6
Meorazhar Confirmed User Industry Role: Join Date: May 2005 Location: ICQ: 5262689 Posts: 672	Hi Lenny, If you're talking about importing tables from SQL database into Ms Access, here is the simpliest way to do it. Obtain an ODBC driver for your SQL database, install it then import the tables into Access using that driver. It worked very well for me with MySQL Good luck.

06-04-2005, 12:13 AM	#8
Antonio Too lazy to set a custom title Join Date: Oct 2001 Location: Spartaaaaaaaaa Posts: 14,136	SQL is a query language, you talking about MySQL?

06-04-2005, 08:13 AM	#10
Sams_gfy Confirmed User Join Date: Aug 2004 Location: in your imagination... Posts: 491	Export to .cvs and import into access __________________ Work with PPC SE ( Umax, 3FN Marketing) and GET PAID FOR EVERY CLICK !!! Next step after PPC - Pay Per Lead/Action Good, filtered traffic: Chocker, Traffic Holder \|\| My favourite hosting: HQ Host

06-04-2005, 08:35 AM	#12
Crypt Confirmed User Join Date: Apr 2004 Posts: 2,225	Download Navicat MYSQL. Its a remote MYSQL software for windows. Just need to enter your unix server ip, user/pass for mysql. You can export,import over 50 extentions direct in your MYSQL database with 1 click. Access, Dbase, XLS, XML, etc etc I use this on a daily basis. Hope it help.

06-04-2005, 08:45 AM	#13
Machete_ WINNING! Industry Role: Join Date: Oct 2002 Posts: 14,579	[QUOTE=Crypt]Download Navicat MYSQL. Its a remote MYSQL software for windows. QUOTE] what he said

06-04-2005, 09:00 AM	#14
MandyBlake The one and only! Industry Role: Join Date: Nov 2002 Location: Atlanta, GA Posts: 17,761	good luck lenny! __________________ Mandy's Playhouse Her First Fat Girl If you're interested in promoting my sites, ICQ me! 178411921