Access genius people needed (linked tables) {sorted} - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » Access genius people needed (linked tables) {sorted}

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

Mikorsa16v

Member

Registered: 2nd Sep 02
Location: Burgess Hill, West Sussex
User status: Offline

12th Jun 03 at 16:39

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?!?

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

any ideas ppl?

[Edited on 12-06-2003 by Mikorsa16v]

Mikorsa16v

Member

Registered: 2nd Sep 02
Location: Burgess Hill, West Sussex
User status: Offline

12th Jun 03 at 16:41

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

Mikorsa16v

Member

Registered: 2nd Sep 02
Location: Burgess Hill, West Sussex
User status: Offline

12th Jun 03 at 17:11

for those of you that care (the people that looked

) 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

M4tt

Member

Registered: 18th Apr 03
Location: Potters Bar
User status: Offline

12th Jun 03 at 22:23

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

New Topic

New Poll