mySQL & TransferSpreadsheet

#1

Hello again, another question: is it im mySQL mechanism
TransferSpreadsheet , similary as in MS Acces, to import data from excel to
mySQL?
MS Acces: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
TblName, myPath, True, range .....

How it to make in mYSQL? Greetings

#2

Adax wrote:

Quote:

Hello again, another question: is it im mySQL mechanism
TransferSpreadsheet , similary as in MS Acces, to import data from
excel to mySQL?
MS Acces: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9,
TblName, myPath, True, range .....

How it to make in mYSQL? Greetings

save file as .csv and look at loadfile READING the docs prior to
posting would save you a lot of time.

google for mysql csv

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

mySQL & TransferSpreadsheet

comp.databases.mysql comp.databases.mysql

mySQL & TransferSpreadsheet - 05-04-2008 , 10:35 AM

Re: mySQL & TransferSpreadsheet - 05-04-2008 , 04:35 PM