[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

Ttable and Txt files

I need to load a comma seperated file into a Ttable. How Must me Txt file look like ??.

I have tried using both Comma,Simicolon and Tabs, but it still loads all the text into one field.

an Example of the text file would be nice


0
kwang080897
Asked:
kwang080897
  • 2
1 Solution
 
PeterLarsenCommented:
I think it would be faster to load the text into a TStringList (TStringList.CommaText) and then insert the text in your database in a loop.

Just an idea !!

Peter

0
 
edeyCommented:
If you really want to use a database drive with you .txt file, here is the borland TI explaining the ascii driver:

http://community.borland.com/article/0,1410,15892,00.html

there is also a TI on converting ascii files to paradox:

http://community.borland.com/article/0,1410,16960,00.html

GL
Mike
0
 
kwang080897Author Commented:
Peter:

You might be right - but my custumor need the other sollution.

Mike:

Thans, Just what I Needed, please submit an answer

Kim
0
 
edeyCommented:
Glad to be of service :)

GL
Mike
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now