473,324 Members | 2,400 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Looking For Wisdom!

Hi all,

I am new to this thread. My dilema is....

I am going to put my website up. However, my DB I need to upload for my shopin cart is in MSAccess and I want to have my website platform in LINUX, sooooo my question is can I convert MSAccess to MySQL and if so, how? And if not, does this mean I have to input one by one 350,000 products, I hope not -- that would be a big bummer. Give me some good news folks, please.

Computer guru's are the best!

Thanks,

The Rookie
Mar 29 '07 #1
1 1389
MMcCarthy
14,534 Expert Mod 8TB
There are a number of ways to approach this.

One approach is to use the export feature provided by Access itself to write out the contents of each table as a text file. Each file then can be loaded into MySQL using a LOAD DATA statement or the mysqlimport command-line utility. Suppose you export a table mytable into a file mytable.txt using CSV (comma separated values) format, and you want to import it into a table named mytable in a MySQL database named mydb. You can invoke the mysql program, then issue a LOAD DATA statement to import the file like this:

Expand|Select|Wrap|Line Numbers
  1. C:\> mysql mydb
  2. mysql> LOAD DATA LOCAL INFILE 'mytable.txt'
  3. -> INTO TABLE mytable
  4. -> FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  5. -> LINES TERMINATED BY '\r\n';
Or you can use mysqlimport from the command line (type the command all on one line):
Expand|Select|Wrap|Line Numbers
  1. C:\> mysqlimport --local --fields-terminated-by=,
  2. --fields-enclosed-by='"'
  3. --lines-terminated-by='\r\n'
  4. mydb mytable.txt
If you need to provide connection parameters such as the hostname, user name, or password, list them on the mysql or mysqlimport command line before the database name:
Expand|Select|Wrap|Line Numbers
  1. C:\> mysqlimport --local --fields-terminated-by=,
  2. --fields-enclosed-by='"'
  3. --lines-terminated-by='\r\n'
  4. -h some_host -p -u some_user
  5. mydb mytable.txt 
The MySQL tables must already exist before you can load data into them, so you must issue the appropriate CREATE TABLE statements yourself.

Alternatively there are a number of tools you can use to import Access into MySQL.

DBTools
Access2MySQL
BullZip MS Access to MySQL

Mary
Mar 29 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Craig S. Ugoretz | last post by:
Dear newgroup readers, I am pleased to announce the presentation of the new open source software project I have created, called the "Wisdom Seeker IDE". For a description of what open source...
4
by: Mick White | last post by:
mysql> select * from guestbook; +----+--------+---------+-----------------+----------------+ | id | fname | lname | comments | time_in |...
1
by: Grunt | last post by:
Hi, I have been trying to put together a rotating banner. the code works but I am having a problem with the caching of the banner images. no matter what I try the page is constantly reloading the...
8
by: Nospam | last post by:
I'm a fairly experienced front end webdesigner without any knowledge of the backend or how to set up a store. I now have a potential job to develop a craft store for someone but will likely have to...
7
by: Joe Wasik | last post by:
Hello, Currently I used Biomobility's DataOnTheRun for the Pocket PC. It's a little slow, but it does exactly what I need -- and it does it well. Unfortunately, now I need to have the same...
8
by: Ben Fidge | last post by:
I have a requirement to compare two lists, generating a third which is a combination of both. With the first list as the reference list and the second as the test list, I want the each of the...
17
by: ToddLMorgan | last post by:
I'm just starting out with python, after having a long history with Java. I was wondering if there were any resources or tips from anyone out there in Python-land that can help me make the...
13
by: Alan Silver | last post by:
Hello, MSDN (amongst other places) is full of helpful advice on ways to do data access, but they all seem geared to wards enterprise applications. Maybe I'm in a minority, but I don't have those...
3
by: antonyliu2002 | last post by:
I am looking for a free reporting package for .net 2.0 against Oracle database 10g. The web application I am working on will let office staff members who don't know much about database generate...
3
by: Carl Youngblood | last post by:
I own the 3rd edition of Stroustrup's THE C++ PROGRAMMING LANGUAGE and have read most of it, but I find its style to be more suitable for reference than for tutorial. I still have a lot to learn...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.