[Webinar] Streamline your web hosting managementRegister Today

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

Append from text file & SQL Truncate Table.

I am accessing a dbase .dbf through ODBC. Need to do the following:

1. Append from non-delimited ascii text to my CDatabase.

2. In SQL there is a TRUNCATE TABLE command. Can this command be run under ODBC?

Thank You
0
rgcomm
Asked:
rgcomm
  • 3
  • 2
1 Solution
 
rgcommAuthor Commented:
Edited text of question.
0
 
inprasCommented:
Hi
No U cannot Use TRUNCATE TABLE for ODBC U have to use DELETE FROM
to do UR operation
Hope this helps
0
 
rgcommAuthor Commented:
Still need the following:

1. Append from non-delimited ascii text to my CDatabase.

2. Other opinions on: In SQL there is a TRUNCATE TABLE command. Can this command be run under ODBC? DELETE FROM is so slow!

Thank You
0
 
inprasCommented:
For appending U have to read the text file using File operations
0
 
rgcommAuthor Commented:
Need more detailed comment on read text file using file operations and a better solution than DELETE FROM.

Thank You
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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