andrewducker (
andrewducker) wrote2004-09-05 01:59 pm
![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
Access is fun!
After becoming increasingly exasperated with Access's complete inability to do anything at a reasonable speed I downloaded PostGres to play with.
Exporting the first table to it from Access failed to work, so I thought I'd break it down the process and see if it worked.
(1) Create a blank table identical in structure to the original table, but without any data in it.
(2) Update this new table with all the data in the original table.
That worked.
Which makes me wonder what, exactly, Access was trying to do the first time that completely _failed_ to work...
Exporting the first table to it from Access failed to work, so I thought I'd break it down the process and see if it worked.
(1) Create a blank table identical in structure to the original table, but without any data in it.
(2) Update this new table with all the data in the original table.
That worked.
Which makes me wonder what, exactly, Access was trying to do the first time that completely _failed_ to work...
no subject
(no subject)