Import ASCII file into MYSQL

[aliceting]

i want to import ASCII file into MYSQL .The ASCII file is .txt file which contain database /records.The file did not contain any deliminator,but have some spacing between data.

so,how do i import all of these content into MYSQL,and doing the database manipulation there.?Please advise.Thank You

 

[peter3244]

Could use the BCP utility

ie from the DOS prompt

BCP [databasename].[owner].tablename in [datafile]/t=' '

You might have to 'fiddle' with the parameters to get it
exactly right

OR You could use BULK INSERT in SQL Query Manager

OR You could use import data by right clicking on the database in Enterprise Manager and selecting all tasks followed by import data. The DTS wizard is then displayed.

Careful that you don't overwrite data that you want to keep.

 

[tlbroadbent]

POst your question in the MySQL forum rather than the MS SQL Server forum. You be more likely to get an appropriate answer.

forum436 - MySQL Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.