converting mdb to sql

RickyG · 03-24-2005, 08:39 PM

Can someone help me covert a mdb to sql?????

This is for a nonprofit site

www.msmoms.com
I have tried a coverter and I didnt understand it...

gamex · 03-24-2005, 09:09 PM

Search google.com for something like "Convert Access to SQL" and you will get results for things like this:

http://www.gold-software.com/download8264.html

A lot of the things I have found cost $$$ though

RickyG · 03-24-2005, 09:18 PM

I just DL that one and I get stummped and cannot get further into the prog. It askes for srver location...default is localhost...but that errors out. i try 127.1.1.1 same thing errors out. I need someone that cando this for me.
Thankyou for the lead.
RickyG

gamex · 03-24-2005, 09:23 PM

Do you know PHP? You can try exporting the Access database to a csv file, then importing the csv file using php. There is a code here: http://codewalkers.com/seecode/448.html

If you want, I can try it. I would need the database and access to phpMyAdmin or whatever you use. If you want me to do this, PM me the details.

Joe

RickyG · 03-25-2005, 04:27 AM

My brain isnt working well.....is there any way you can do it and converting it without using mysql?

03-24-2005, 08:39 PM	THREAD STARTER #1 (permalink)
RickyG Senior Member Join Date: Jul 2004 Location: Boston Posts: 1,532	converting mdb to sql Can someone help me covert a mdb to sql????? This is for a nonprofit site www.msmoms.com I have tried a coverter and I didnt understand it... __________________ Brand new BlackBerry forum, help support a fellow NP'r This site STINKS!! Last edited by RickyG; 03-24-2005 at 08:57 PM.

03-24-2005, 09:09 PM	#2 (permalink)
gamex NamePros Regular Join Date: Feb 2004 Location: Student @ UConn Posts: 411	Search google.com for something like "Convert Access to SQL" and you will get results for things like this: http://www.gold-software.com/download8264.html A lot of the things I have found cost $$$ though __________________ Joe

03-24-2005, 09:18 PM	THREAD STARTER #3 (permalink)
RickyG Senior Member Join Date: Jul 2004 Location: Boston Posts: 1,532	I just DL that one and I get stummped and cannot get further into the prog. It askes for srver location...default is localhost...but that errors out. i try 127.1.1.1 same thing errors out. I need someone that cando this for me. Thankyou for the lead. RickyG __________________ Brand new BlackBerry forum, help support a fellow NP'r This site STINKS!!

03-24-2005, 09:23 PM	#4 (permalink)
gamex NamePros Regular Join Date: Feb 2004 Location: Student @ UConn Posts: 411	Do you know PHP? You can try exporting the Access database to a csv file, then importing the csv file using php. There is a code here: http://codewalkers.com/seecode/448.html If you want, I can try it. I would need the database and access to phpMyAdmin or whatever you use. If you want me to do this, PM me the details. Joe __________________ Joe

03-25-2005, 04:27 AM	THREAD STARTER #5 (permalink)
RickyG Senior Member Join Date: Jul 2004 Location: Boston Posts: 1,532	My brain isnt working well.....is there any way you can do it and converting it without using mysql? __________________ Brand new BlackBerry forum, help support a fellow NP'r This site STINKS!!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Plesk & SQL help	TLDnetworks	Web Hosting Discussion	1	03-04-2005 11:11 PM
ASP same as SQL?	RickyG	Programming	5	02-12-2005 08:33 AM
Connecting to your SQL Database using Enterprise Manager	priyanka[imported]	Web Hosting Discussion	1	12-07-2004 04:21 PM
Connecting to your SQL Database using Enterprise Manager	priyanka[imported]	Webmaster Tutorials	0	12-06-2004 09:58 PM
sql database	redhippo	Programming	4	11-08-2004 07:43 AM