Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Importing an access table in mysql
- Thread starter itechC
- Start date
sleipnir214
Programmer
You export could the records into a CSV and import them into MySQL using its LOAD DATA INFILE query.
You could use MyODBC and export the records to MySQL from within Acess using Access' export tool.
Some Win32 tools to manage MySQL will also allow extraction and importation of records through the tool. MySQL-Front, for example, does this.
Want the best answers? Ask the best questions!
TANSTAAFL!!
You could use MyODBC and export the records to MySQL from within Acess using Access' export tool.
Some Win32 tools to manage MySQL will also allow extraction and importation of records through the tool. MySQL-Front, for example, does this.
Want the best answers? Ask the best questions!
TANSTAAFL!!
- Status