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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-16 : 22:23:31
|
Scott writes "I am using DTS to import data from dbf files. (I didn't choose the format, but it is the most advanced format I can get from a guy running DIBOL on a PDP-11 with 9-track tapes.) I agree with your opinion of DTS and its limitations. It is difficult to do things I could do easily in T-SQL, there is no good way to document the process, etc.
I suppose I could just use DTS to import the data and then have it execute a stored procedure to do the transformations needed (the PDP-11 guy also doesn't believe in normalization), but I would like to dispense with DTS altogether. I have not been able to come up with the right parameters for OpenRowset. Depending on whether I use the MSDASQL or Jet provider, I can get error message saying "data source not found and no default provider" or "cannot find installable ISAM". I have read the manuals, the help files, and MSDN, and the closest examples I can find are for opening an Excel spreadsheet, but no variations of these examples have worked.
Since DTS (and Access, Excel, etc) have no problem reading dBase files on my system, there must be a way. Can you help me?" |
|
|
|
|
|
Using OpenRowset with dBase files