I can't find Foxpro in the list of Db to import? 3

[steve728]

I'm forced to use "dBase III" argument to import Foxpro data with MS Access 2000/2002. As a result I cannot import DBFs with a memo file included. The only way to import is to install Access 97 and import manually.

I tried "Foxpro", "Foxpro 2.6" and "Foxpro 3" in the following line of code with no success. Any ideas, tips...

DoCmd.TransferDatabase acLink, "dBase III", "C:/CWUA/", acTable, "STORAGE.DBF", "STORAGE"

Steve

 

[BitFuzzy]

import file type odbc databases()

from there you will find options for FoxPro

 

[steve728]

I'm a bit new at this process. Would you please provide me with the proper syntax to use based on my sample above?

Thank you so much thus far.

Steve

 

[BitFuzzy]

You want to import from your dbf into access? :
1. open access
2. select file | get externel data | import
3. move to the directory where your dbf is located
4. in "files of type" change the listing to 'odbc databases'
5. dbl click on fox pro files word
6. check Free Table Directory
7. slect Browse and make sure you are in the proper directory
8. click ok
9. select the dbf you want and click ok
10. from there you should see a new database in your access panel, just double click on it to work with it

 

[steve728]

Thank you friend!!!!!!!

 

[steve728]

It works great! Is it possible to get the same results with VBA code? If so please show me the proper syntax.

Thanks again!

Steve

P.S. I sent you a star. You deserve it for your quick, helpful replies!

 

[BitFuzzy]

dunno, never tried it.. but you could always play around (just remember to back the file up first incase you end up corrupting it lol)

 

[steve728]

I just tried the same process above on a PC that has the Home addition of WinXP and Office 2000. When pulling down the tab that displays the "Foxro files word" it wasn't there. There is hardly anything to pick from. What is the reason for this? Is it that Home Edition version of XP does not include these additional choices or is it that I need to install Office XP professional? My computer that does work has WinXP Pro and Office XP Pro.

 

[rgbean]

Steve,
Have you installed the VFP ODBC driver? It's not included with a standard XP (Home or Pro) install. Go to

http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

to get the files necessary for this install.

Rick

 

[steve728]

Thank you! Thank you! Thank you!
You get a star! I really need this info today.
Have a great productive day!

Steve