1 reply to this topic

[Tirus]

Hello guys,

I was recently approached by someone who wanted me to convert Microsoft Access files with a bunch of business listings in them into SQL files for uploading to a website, something similar to the yellowpages.

I have worked with MySQL (the very basics) before but I'm not sure how close this falls to that category. I did some quick research and found that I can use the Upsizing Wizard within Microsoft Access to convert my access files to SQL. The problem or concept that I am not understanding is that of an SQL Server. In order to use this conversion wizard, you need to specify an SQL Server. Well....being that I do not know much about SQL Servers etc, I don't really know if I have an SQL server or how to get one if I don't. Is an SQL Server the same thing as PHPMyAdmin and uploading SQL into that? I also read somewhere that you need or could use Visual Basic, something else that I don't have.

Am I in over my head? Can someone clarify for me what an SQL Server is, how to obtain one and overall, how to convert an access file to sql for uploading.

Thanks,

Tirus.

[rc69]

phpMyAdmin isn't a server, it's a program. An SQL server is exactly the same as a PHP server, except that it is made to handle SQL and not PHP. You can check http://www.mysql.com/ for info on buying theirs. Or you can search the forums, quite a few have been mentioned.

If i'm right, the only reason you have to specify a server is so it gets the proper syntax. For instance, there are differences in the parsing rules for mySQL 4 and mySQL 5, so it would have to do something different for each. So you most likely don't have to install anything, just find out what your host has.

Edited by rc69, 28 June 2006 - 02:13 AM.