Topic started by tabassum (@ 61.1.186.106) on Thu May 16 05:01:19 .
All times in EST +10:30 for IST.

I want to convert huge data which is in Text format in to sql table, if any body knows please help in this. for which act i shall be remember them for ever.

Responses:

• From: Milton (@ lunar-gw.zapsurf.com.sg) on: Thu May 16 07:30:22
  
  Please be more precise.Do you want to store huge text content in Oracle or SQL server?
  
  
• From: selvam (@ palo20.pacific.net.sg) on: Thu May 16 10:56:31
  
  in which format is it in?
  if you could send me a sample it will be good
  
  
• From: tabassum (@ 61.1.186.107) on: Sat May 18 07:50:08
  
  hello milton and selvan
  
  thanks for your response
  
  i dont want to enter the data in sql table,origianlly it is in dbf
  form and i converted it into text format (i.e.*.txt). and again
  converting the whole data in to the existing sql table which is
  having same field names and length.
  
  that is it
  
  please help
  
  
  
  
  
  
• From: selvam (@ palo15.pacific.net.sg) on: Sat May 18 10:40:05
  
  use the import facility from the sql server to import text files or create a ODBC string choosing the txt driver and table is your txt file. then you can import to any ODBC compliant database
  
  
• From: selvam (@ palo15.pacific.net.sg) on: Sat May 18 10:42:24
  
  use the import facility from the sql server to import text files or create a ODBC string choosing the txt driver and table is your txt file. then you can import to any ODBC compliant database
  
  
• From: tabassum (@ 61.1.186.123) on: Mon May 20 04:34:10
  
  thank you mr.selvam i will try this.
  
  
  

Want to post a response?