Solved

mySQL Inquiry

Posted on 2004-08-06
4
381 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 50 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Article by: Matthew
I am a very big proponent of technology compliance standards and strive to meet such criteria in all of my work. That includes my site, which is 100% XHTML 1.0 compliant as determined by the World Wide Web Consortium. https://www.matthewstevenkel…
This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…
Suggested Courses

624 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