Adding All Rows From One Table to another table in Access

[PaidtheUmpire]

Is there a way in Delphi to do the following.

1) Clear all records in a table named "XXXXXX"
2) Copy all records from one table "XXXXXX" into a different table "Call_Records"

or

1) Copy a large amount of records in a textfile called "TheList.txt" into a database table "Call_Records".

Delphi I can't get enough of you.

 

[kittyyo]

> 1) Clear all records in a table named "XXXXXX"
> 2) Copy all records from one table "XXXXXX" into a
> different table "Call_Records"

I would do this using SQL, like
1) DELETE * FROM XXXXXX;
2) SELECT * FROM XXXXXX INTO Call_Records; (roughly, the table structure of XXXXXX and Call_Records has to be the same)

What is the format of your text file?

 

[PaidtheUmpire]

The format of the file would be...

1000103,901032140015983,300001001953390,0061732299576        ,2/04/05 8:55:53,29,$0.31,$2.20,00505,Data,AUD,Yes,IrdAusD,40,cdusa77FASTW03349.dat,4,More Sections

That was all one line with commas "," seperating the columns. It is also in the correct order.

Thanks,
Rick

Delphi, Delphi, Delphi. Oi! Oi! Oi!

 

[PaidtheUmpire]

Well,

does anyone have any ideas?

Delphi, Delphi, Delphi. Oi! Oi! Oi!

 

[donvittorio]

see the current post titled 'Importing txt into Access DB' started by warlock 0199 (thread102-1041549)

Steve