How to import tabledata through a textfile

This topic is empty.

Viewing 5 reply threads

Author

Posts
- September 3, 2004 at 12:21 pm #8556
  
  Papy
  Member
  
  Hi,
  
  I want to import a table with data from a textfile ???
  
  How it can be done???
  
  Thanks.
- September 3, 2004 at 1:42 pm #16251
  
  Ritesh
  Member
  
  Is it in CSV format?
- September 6, 2004 at 8:00 am #16252
  
  Papy
  Member
  
  Yes its a .txt file in csv format please explain in detail what steps should i follow in order to import that file in sqlyog
  
  Thanxx in advance.
- September 6, 2004 at 11:02 am #16253
  
  Ritesh
  Member
  
  Select the table in the ObjectBrowser.
  
  Select Table -> Import Table Data From CVS… . Enter the filename and the correct escaping sequences and press Import. Thats it 🙂
- September 6, 2004 at 6:23 pm #16254
  
  peterlaursen
  Participant
  
  if the amount of data is not astronomic and if your are in possision of MSOffice you can consider another solution (that gives more control).
  
  1)Read the text-data into Excel
  
  2)Save as excel-datafile (.xls)
  
  3) Create an empty database i MySQL using Sqlyog
  
  4) Open the excel-datafile from Access
  
  5) Export from Access via ODBC to Mysql
  
  6) Correct tabledefinitions if necessary (for instance Mysql has much more text-types than Access) using sqlyog.
  
  7) Create the indexes that you need and perhaps a primary key using sqlyog.
- September 7, 2004 at 1:04 pm #16255
  
  Shadow
  Member
  
  Why does your solution offer more control over directly importing to MySql?
  
  I see no cause why a textfile should be transferred through 3 apps to get to MySql…
Author

Posts