2. PHPRunner General questions
  3. Uploading data into MySQL Database
This topic is locked

Uploading data into MySQL Database

 		11/1/2006 7:28:37 AM
PHPRunner General questions
P
 PMCrosby author

I have a Access database and Sage accounts file with some company data in it,
I know how to create a CSV file but am struggling to upload the data.
Any help would be apprechiated
Alexey admin 11/1/2006

Peter,
you can create a PHP script for this or use some specialized database conversion software.
Unfortunately PHPRunner wouldn't help you here.
T
 		thesofa 11/1/2006

The basic principle is to create the csv file with the column headings as the first row.

Save it, then use something like the Navicat demo or MYSQL GUI Tools from MYSQL AB Site

Then you will be able to import the scv file and create the tables from the headings, Navicat will allow you to import the data and table structure directly from access tables

HTH