If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Other PC Databases > Exporting from Foxbase / pro / plus

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 07-16-07, 08:20
FOXPLUS FOXPLUS is offline
Registered User
 
Join Date: Jul 2007
Posts: 1
Question Exporting from Foxbase / pro / plus

Is this possible, it looks like it was from the dark ages!
any help would be great! would really like to get the data into excel!
Reply With Quote
  #2 (permalink)  
Old 07-16-07, 08:33
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
I beleive you want something along the lines of
Code:
USE MyTable
COPY TO MyWorkbook TYPE XL5
*--+ OR
USE mydbf IN 0
EXPORT TO c:\MyWorkbook.xls TYPE XL5
Hope this helps
~George

EDIT: This is using the Command Window
There are other methods but this would probably be easiest - let us know how you get on please!
__________________
George
Twitter | Blog

Last edited by gvee; 07-16-07 at 08:37.
Reply With Quote
  #3 (permalink)  
Old 08-27-07, 14:37
Sam Landy Sam Landy is offline
Registered User
 
Join Date: May 2004
Location: New York State
Posts: 936
Have you tried Microsoft Query?

Sam
Reply With Quote
  #4 (permalink)  
Old 08-28-07, 14:45
loquin loquin is offline
Super Moderator
 
Join Date: Jun 2004
Location: Arizona, USA
Posts: 1,797
Try opening the files from within Excel. In the file browse form, look at the file type. Foxpro files are based on dbase, so you might be able to use that option.

If you don't have the odbc drivers/oledb providers installed, re-install Excel; you have the option of adding additional drivers/providers in the custom install.

Now, depending upon your MS Office version (Office 2002 or greater,) you may need to use the FoxPro ODBC driver. Ref this MS KnowlegeBase article. (although this link is specific to Access, it should also work for Excel) I would recomend that create a file dsn using the FoxPro ODBC driver, and store it in an easily accessible location.

Then, from Excel, one of the file open dialog file type options is for "All Data Sources," which includes DSN files.
__________________
Lou
使大吃一惊
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On