Apppend Records to a table

[Guest]

I know it can be done via code & committing a transaction.

When trying to copy records via the Clipboard & adding them in "Records -
Data Entry" works...as long as it's "not too many records"...I pasted 600
records at a time...trying for 5000 records choked the Clipboard.

TIa - Bob

 

[RobFMS]

Bob

I am not sure what your question is here. If 5K of records is choking the
clipboard, then reduce the amount you are selecting. The clipboard may rely
on available memory, which can vary from machine to machine.

--
Rob Mastrostefano

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

 

[Guest]

Rob - Thank you.

That's what I did...I pasted a bunch of "600 records" at a time. It was at
a small Company where someone else, now deceased, had written the DB. I knew
it would work that way, but it took 2 hours on a slow PC.

I elected not to write code, knowing the slow, tedious way would restore ALL
their data of 78000 records - there were 2 "bad" records in there...one had
the "#Delete" in all the fields & I couldn't delete the Record. The 2nd Bad
Record was found (and it looked perfectly OK) by running a Make-Table Query &
realizing
the Record didn't get to the New Table. Actually, that was fun finding that
needle in the haystack.

Other thoughts please?

TIA - Bob