Populating Two Tables from text file without Autonumber <<<<<<<<<<< 
Author Message
 Populating Two Tables from text file without Autonumber <<<<<<<<<<<

I have a User Database made up of two tables (A= ID, UserID and Password B=
ID, Name and address). The text file does not contain an ID number.

A and B have relationship set with Ref. Integrity to the ID fields. The ID
fields in the tables are NOT Autonumber (Number/Long Integer).

As I import each new record it needs to increment the ID of the last record
by 1 and then insert the data from the text file into the rest of the fields
in the two tables, then move on, incrementing as it imports each new record.

I can't get this to work. As an experiment I tried setting ID to Autonumber
and it worked, but since the tables have thousands of records already I
can't do that in the actual working db.

If it matters or helps, the text file is only one field that I need to
duplicate into every field, then increment it's ID number by 1 and then
insert the next and so on.



Sat, 02 Sep 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. French Canadian Spell Check <<<<<<<<<<<<<----------------help!

2. stupid question <<<<?????

3. ~~<|<|<|<*(#@#@@@&!!!^ATTENTION^!!!&@@@#@#)*>|>|>|>~~

4. PPT Presentations on the Web <<<<<<<

5. <crtl><home>, <crtl><end>, <crtl><right arrow> does not work

6. <><><> missing command <><><>

7. {{<<<~!!!@@^ATTENTION^@@!!!~>>>}}

8. {{<<<~!!!@@^ATTENTION^@@!!!~>>>}}

9. {{<<<~!!!@@^ATTENTION^@@!!!~>>>}}

10. {{<<<~!!!@@^ATTENTION^@@!!!~>>>}}


 
Powered by phpBB® Forum Software © phpBB Group