Our application was first developed using an access97 DB and has since been
upgraded to use an MSDE DB. While the data in the DB is basically the same
the table structure in the MSDE has been normalized quite a bit and uses a
lot more smaller tables.
We now have the task of exporting the data from the access97 DB into the
newer MSDE DB so that our clients can use the new application.
What is the best method to accomplished this?? Any ideas appreciated. I
was thinking about exporting the access97 data into a delimited file and
using BCP - Good or Bad idea??
Thanks in advance,
Remove NOSPAM when replying