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-09-28 : 09:12:53
|
| Bonnie writes "I am using Visual Basic 6.0 and SQL Server 7.0On a SQL Server I have a DataBase Called MYDATA and one of the tables in that database is BONORDS. I would like to export the data into a .DBF (DBASE III) format. I did transfer the data using the Wizard but I need to do it in Visual Basic. User needs to enter 2 conditions. Can you give me an example how to import and export the data from either DBASE III or FOXPRO using free table. Thank you, your help will be greatly appreciated.So far what I found is that the SELECT command goes somehow like this:SELECT *INTO [some external driver, external file name] FROM [SQL Table]In my case would be SELECT *INTO [ ?????? BONORDS.DBF] FROM[BONORDS](But I need to trow 2 conditions in it)" |
|
|
|
|
|
VB, MSSQL7, EXPORT, IMPORT