Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hasanali00
Posting Yak Master
207 Posts |
 Posted - 2005-07-20 : 15:55:27
|
| 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 appraochregards |
|
|
hasanali00
Posting Yak Master
207 Posts |
Posted - 2005-07-21 : 15:28:18
|
| i guess, no one understood my question |
 |
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-07-21 : 21:19:39
|
| Create a view with the columns named as they are needed.Then I would use a DTS package to export the data to the dbf file.Note: I don't use DTS myself much but it has the option to DBF on the text file destination ICON.Tim S |
|
|
|
cruisinfriend
Starting Member
3 Posts |
Posted - 2005-08-25 : 05:58:24
|
| Hi. I have tried migrating data from SQL server tables to Dbf file using DTS. It was successfully created, but the numeric type column was always set to Numeric(20,5) even I defined different numeric precision.I also need help on this. Anyone, please.Thanks. |
|
|
|
|
|
|
Migrating data into dbf file