GaryAtWork
Board Regular
- Joined
- Dec 19, 2005
- Messages
- 83
Hi,
I'm trying to duplicate a column in an access table which has just short of 4 million records.
My initial thought (being fairly clueless in Access) was to copy and paste from the existing column into a new blank column but it tells me there is a limit to what will fit on the clipboard and it would mean 60 copy and paste operations to do what I want.
Is there a simple way to do what I'm trying to do?
In Excel I could just about manage vba to do it but I have no idea in Access.
Thanks for any help.
I'm trying to duplicate a column in an access table which has just short of 4 million records.
My initial thought (being fairly clueless in Access) was to copy and paste from the existing column into a new blank column but it tells me there is a limit to what will fit on the clipboard and it would mean 60 copy and paste operations to do what I want.
Is there a simple way to do what I'm trying to do?
In Excel I could just about manage vba to do it but I have no idea in Access.
Thanks for any help.