I'm working with legacy software that was built with Visual Foxpro. While there is a Vfpodbc driver that will allow linking to and importing the data from the .dbf tables into Access, it is 32-bit and i have since been forced to upgrade to 64-bit Office and can no longer use this driver. On top of that, to use the driver I would have to install it and setup a DSN on every computer that would need to use any potential databases that would need to link/import these tables. I'm an engineer, not IT, and i don't have the time to set that up and manage it should there be issues in the future.
This isn't a big deal because the legacy software in question does have the ability to export tables to excel and i can link/import those no problem. My only issue with that is some of the databases I've built for my coworkers require multiple tables to be dumped out of our legacy software and some contain 100k + records so it can take a long time (and some of my coworkers aren't very tech savvy, to say the least, so they mess up the data dumps quite often unfortunately...). The ODBC driver was the only "solution" i found that would remove the need to manually dump out the tables into a format that access can use.
I know in Excel you can use Microsoft query, but i'm not sure if that can be automated.
My next thought is that maybe i can write Foxpro code that can export the .dbf files to excel and i can run a shell command to trigger that foxpro code file to automate the file type conversion that i want. The problem there is i have no idea where to find a Foxpro IDE to write the code file.
So that's the background of what I'm working with and leads me to the following 2 questions:
1. Can I automate Microsoft query or does anyone know of any other way (besides using the foxpro odbc driver) that i can automate dumping the .dbf files' contents into or Excel or directly into Access? Also i think i might still need the driver for this to work...
2. Does anyone know where to get access to a Foxpro IDE? Even if i could get access to one, will i be able to use it in a 64-bit system?
Any help is appreciated!
This isn't a big deal because the legacy software in question does have the ability to export tables to excel and i can link/import those no problem. My only issue with that is some of the databases I've built for my coworkers require multiple tables to be dumped out of our legacy software and some contain 100k + records so it can take a long time (and some of my coworkers aren't very tech savvy, to say the least, so they mess up the data dumps quite often unfortunately...). The ODBC driver was the only "solution" i found that would remove the need to manually dump out the tables into a format that access can use.
I know in Excel you can use Microsoft query, but i'm not sure if that can be automated.
My next thought is that maybe i can write Foxpro code that can export the .dbf files to excel and i can run a shell command to trigger that foxpro code file to automate the file type conversion that i want. The problem there is i have no idea where to find a Foxpro IDE to write the code file.
So that's the background of what I'm working with and leads me to the following 2 questions:
1. Can I automate Microsoft query or does anyone know of any other way (besides using the foxpro odbc driver) that i can automate dumping the .dbf files' contents into or Excel or directly into Access? Also i think i might still need the driver for this to work...
2. Does anyone know where to get access to a Foxpro IDE? Even if i could get access to one, will i be able to use it in a 64-bit system?
Any help is appreciated!
Running too fast with scissors today
