?
Solved

mySQL Inquiry

Posted on 2004-08-06
4
Medium Priority
?
392 Views
Last Modified: 2010-04-06
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>
0
Comment
Question by:juggernux
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 8

Accepted Solution

by:
dds110 earned 200 total points
ID: 11736119
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question