We help IT Professionals succeed at work.

About bcp

amol_kokate
amol_kokate asked
on
Can u use bcp to import data from dbf file?
If yes, tell me how?
Comment
Watch Question

Commented:
export data from dbf as comma delimited and then use bcp command from command line.
Alternativley you could use the DTS and connect via ODBC to import the data. I'm assuming your dbf is Foxpro
if it is there are drivers for bot foxpro and visual foxpro

Author

Commented:
i have done it using dts. and its very fast.
but can u get same result using bcp. i want it to be inserted in SQL from dbf itself. no conversion to comma delimited and all.
There has been no activity in this question in quite some time, and it looks like it has been abandoned. As part of our ongoing mission to clean up the topic areas, a Moderator will finalize this question within the next seven (7) days. At that time, either I or one of the other Moderators will force/accept the comment of deestuar.

DO NOT ACCEPT THIS COMMENT AS AN ANSWER. If you have further comments on this question or the recommendation, please leave them here.

amol_kokate,

Some of these questions have been open for some time.. Please resolve them appropriately as soon as possible. Continued disregard of your open questions will result in the force/acceptance of a comment as an answer; other actions affecting your account may also be taken. I will revisit these questions in approximately seven (7) days.

http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20209786
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20245173
http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20249300
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20189852
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20191231
http://www.experts-exchange.com/jsp/qShow.jsp?ta=mssql&qid=20238054

Thanks,

Netminder
Community Support Moderator
Experts Exchange
Force/accepted by

Netminder
Community Support Moderator
Experts Exchange

Explore More ContentExplore courses, solutions, and other research materials related to this topic.