Hi all,
I have a new project with vb.net.
I need to always connect with older program that run in foxpro, i need to get dbf table and convert it to mysql table.
Can anyone help me ?
Edy_3 0 Newbie Poster
rproffitt 2,662 "Nothing to see here." Moderator
Convert or connect? Two entirely different problems to solve.
Convert may have use export to a common format and import to SQL. Given all that's on the web, I'll stop here.
Connect to an existing DBF might be what you really wanted. Google shows me I shouldn't write more: https://www.google.com/search?q=vb.net+dbf+connection+string
DGPickett 20 Newbie Poster
JDBC tools like SQuirreL and jisql let you extract schema and data. I like to use LINUX sed to pipe a select into an insert, no intermediate files.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.