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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-08-04 : 06:39:12
|
| GurusI have a .dbf file and i want to import data into sql server.If i select dbase in source in export/import wizard it asks me for dsn and username and pwd.Please guide me thru thr processRegardsNitin |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-08-04 : 06:48:44
|
| I sort of...umh...stole this from another forum:"Create a DSN using the driver 'Microsoft Foxpro VFP driver', choose the Database type as 'Free Table Directory' and path as the path for the DBF files. Then choose this DSN as your source under DTS."To create a DSN you need to go to Administrative Tools -> Data Sources (ODBC) -> System DSN -> Add...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-08-04 : 07:20:11
|
| yup i got your point.i have followed the steps what you wrote,but what should i write in username and pwd.Regards |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-08-04 : 07:39:06
|
| Hm, if you didn't create one when you made the DSN I guess you can just leave them blank...? Have you tried it?--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-08-04 : 07:41:13
|
| I don't have the right drivers installed so I can't try it myself--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-08-04 : 10:29:47
|
| HiYes i have tried it but then i dnt see anything in user and destination in the next step...RegardsNitin |
|
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-08-04 : 13:33:38
|
| nitin,When I just tested this (on Windows 2000) the VFP ODBC driver didn't ask for a username or password. Are you sure you selected the right driver?Ken |
|
|
|
|
|
|
Importing data into sql server from .dbf file