Wednesday, March 28, 2012

Migrating data into dbf file

I have to migrate datat from my table to my accounting system.

The table fields of the accounting system are different from my sql table and the Acc sys accepts only .DBF files.

I would have to migrate the data daily.
So my question is: whats the best approach for doing this work.
Should I create a nother table in Sql Server with the field names as the dbf file and write a SP to get all the data from another tabel into this one and then using export wizard to export data into a dbf file.
Or is there any better appraoch
regards

Hi,
Perhaps the better approach is a Data Trasformation Service scheduled daily.
Best regards

No comments:

Post a Comment