mySQL Inquiry

Hi I have a problem. I am creating a ala mini local e-commerce site. My customer wants to upload a database file to our server to update his catalog. I have created a flow of my program and settled on using Access, so that they will upload only their products.mdb to our server and I will be using ASP.net. But here is my problem. They have their database file on a Clipper and they will convert it to mySQL file. If I am going to use mySQL Server will I still be upload their files ala Access files? or they will still attach their DB files ala SQL Server?

Thanks and please email me the answer at <removed by PashaMod for users privacy>
juggernuxAsked:
Who is Participating?
 
dds110Commented:
juggernux

Normally, the members at EE will not send comments to personal email addresses.  This prevents everyone from seeing the proposed solutions and this site is all about helping people.  I've posted a question in the Community Support (CS) Topic Area (TA) in order to get you, AND me, more guidance on this.  Perhaps a few more Experts can chime in here.

As for you question:

So long as your web server supports both db engines (i.e.  MS Access and mySQL), then it shouldn't be a problem to "grab" the data from mySQL and "throw" it into the access database.  You will need to set up at least two ADODB (or DSN) connections to handle the transfer.  1 for Access and 1 for mySQL.  You shouldn't have too much trouble writing the code necessary to:

1. Upload the mySQL file
2. Open mySQL file
3. Open Access
4. Transfer Records from mySQL to Access (with the before mentioned ADODB connections)
5. Close both files

If you do need help with the code, we'll be more than happy to help you out.......Just ask.

HTH
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.