Hi there. Our company is currently migrating from Access to SQL so i am getting a crash course in SQL and ODBC. We are still using DBFs so i need to find a way to import and export DBFs to SQL programmatically (through VB.NET).
I've looked around the net and it sounds like I will need two ODBC connection strings, one for the SQL server and one for my DBF table. Once I established my connection how would i transfer the data - can I use a simple insert query? How would this look?
Thanks in advance for your help