Hi
i need to inser the .dbf file records into sql table.
How should i go about it?
regards,
Kiran
Care to expand on what a .dbf file is and what it looks like inside?
/Kenneth
|||Hi Kiran, Have you used BCP before? Is your question concerning how to use BCP or do you need instructions on using the FoxPro and Visual FoxPro OLE DB data provider to set up your BCP? What have you tried to do so far? What troubles have you had? -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy_winegarden@.msn.com www.cindywinegarden.com> i need to inser the .dbf file records into sql table. >
> How should i go about it?|||Hi KeWin, DBF-extension tables can be created by several different apps, but in general they are FoxPro or Visual FoxPro tables. They are readable via the FoxPro and Visual FoxPro OLE DB data provider, and older tables are also readable via the FoxPro and Visual FoxPro ODBC drivers. -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy_winegarden@.msn.com www.cindywinegarden.com
> Care to expand on what a .dbf file is and what it looks like inside? >
> /Kenneth >
>|||
Hi,
yes i have used bcp to export data in a csv file to a remote machine. But now i want to make a bulk insert of data from a dbf file to sql server 2000 database table.
This can be done through DTS but my question is that is it possible by bcp? if yes then how?
~Kiran
|||Hi Kiran, Rather than BCP you could set up a linked server and then use Insert Into ..... Select. -- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP cindy_winegarden@.msn.com www.cindywinegarden.com> Hi, >
> yes i have used bcp to export data in a csv file to a remote machine.
> But now i want to make a bulk insert of data from a dbf file to sql
> server 2000 database table. >
> This can be done through DTS but my question is that is it possible by
> bcp? if yes then how? >
> ~Kiran > > >
>
没有评论:
发表评论