Saturday, November 24, 2007

How to import Excel, Access or XML data into MySQL database by using a MySQL Client Tool – Navicat?

How to import Excel, Access or XML data into MySQL database by using a MySQL Client Tool – Navicat?

Import excel file into mysql database - MySQL

Import excel file into mysql database - MySQL: "LOAD DATA LOCAL INFILE 'e:\\sydnet2\\_info\\curdocs.csv' INTO TABLE pnp_docs_current FIELDS TERMINATED BY ',' ENCLOSED BY ''' LINES TERMINATED BY '\n';"

Import data from excel to dataset

Import data from excel to dataset: "These articles should provide all the answers you need: Uploading files (optionally into a database) http://SteveOrr.net/articles/EasyUploads.aspx Export to Excel http://SteveOrr.net/articles/ExcelExport.aspx Import from Excel http://www.dotnetspider.com/technolo...ages/1080.aspx -- I hope this helps, Steve C. Orr, MCSD, MVP http://SteveOrr.net 'Schultz' <> wrote in message news: ups.com... >I would like to know if it is possible to import data from MS Excel > 2000 to a dataset using asp.net. The excel file would need to be > uploaded to the server from a web page first, before the loaded into a > dataset. After the data is stored in the dataset, i would need to write > the information to an access db. If it is possible to do this, where > can I find help on how to import excel data to a dataset? >"

Monday, November 19, 2007

About Me

I am from india