well done for sortin it! i thought i'd have a look in the thread, i don't know why though because I'm not a genius and i know nothing about programming

:lol:

for those of you that care (the people that looked :P) i have figured it out and have done it

i had to ask my mate who is programming the C++ to text file to write to the file and not to append to it, so then i use that table as a temp table then i use an append query to append it to a table with a primary key

woo - it works, but for how long ;)

that wasnt my data entry BTW is the text file from my mates C++ program! :lol:

im stuck again, i am using a text file with acces using this as a linked table.




this is the linked table which is from the text file (notice no bloody primary key)
i basically want this data above as a table
i have tryed using this as a temp storage area then using an append query to append this to another table the only problem is with this is that the file will have data appended to this so every time the data from the text file will be repeating data - no good

all i want is the above data to the below data?!? :boggle:



if i could i would use the linked table as a proper table, but i cannot make a primary key out of this, so i thought i could transfer the data to another table

hope some of this makes a little bit of sense :P

any ideas ppl?

[Edited on 12-06-2003 by Mikorsa16v]