Question about Microsoft Excel for PC

2 Answers

How to convert exel file to foxpro file

I have a exel file and want to convert it in foxpro table

















Posted by on

  • 2 more comments 
  • vaishali83 Dec 06, 2008

    hi

    I have a excel file and want to convert it in foxpro 8.0 .can you please help me.(having microsoft office 2007)

  • Anonymous Dec 10, 2008

    how to convert exel file to foxpro file problem,

  • vaishali83 Dec 16, 2008

    Hi
    I have a excel file containing lots ot record more then 5000 so cannt do data entry manually in my foxrpo 8.0 software.I want a solution to convert all the data containing in excel 2007 in foxpro 8.0 dbf . I already tried import option of foxpro 8.0 but it shows error that microsoft excel version is invalid or corrupted and in excel 2007 I didnt found export option .please tell me any solution.

    Thanks
    Regards
    vaishali maske

  • vaishali83 Dec 16, 2008

    Hi
    Can you send me the appropriate solution.please

    Thanks
    Regards
    vaishali maske

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 9 Answers

Open your excel sheet - goto file - save as - type file name - save as type DBF 3 (DBASEIII) - close excel and try opening file from within foxpro

Posted on Feb 23, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Sniper:

    An expert who has posted more than 50 answers, of which 90% or more were rated as helpful.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 53 Answers

You can import the Foxpro file after you've used the DataConnection Wizard. You'll find this under the Data tab in Excel 2007 - under Get External Data section and click on From Other Sources

http://office.microsoft.com/en-us/excel/HP102017101033.aspx?pid=CH100648471033#Importing%20data%20by%20using%20the%20Data%20Connection%20Wizard

Posted on Aug 05, 2008

  • Yumio Saneyoshi
    Yumio Saneyoshi Aug 05, 2008

    Sorry, now I realize you are trying to do the reverse. Let me look into that.

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to fix corrupted Visual FoxPro 9 dbf, dbc?


"Not a table" means more serious problem than TABLEVALIDATE can fix obviously. Also when DBF recovery fails the problem can be critical (if you have the DBF recovery which supports your DBF file format).

You should look at the DBF header via some hexa editor. You may even use the one from VFP:

DO HOME() + "Tools\HexEdit\HexEdit.app"

It will ask for a file opening so please select your DBF and post first two lines here or look at the DBF structure description in the VFP help.

First two lines (in hex editor) contain the file type, number of records, record size, last update etc. "Not a table" means the first byte was not recognized as valid DBF file marker.
Additional lines contain column descriptions each one in 16 bytes.

More info: http://msdn.microsoft.com/en-us/library/st4a0s68(v=vs.80).aspx
Second easiest fix is use DBF Recovery Toolbox or some other applications. Search in Google. http://www.oemailrecovery.com/dbf_recovery.html

Jan 17, 2016 | Microsoft Visual FoxPro 9.0 Professional...

2 Answers

Database file appears corrupt: Page is of wrong type


At the start you could try have an environment under which the table is NOT validated when it is opened. This can be achieved with the command -
SET TABLEVALIDATE TO 0
0 being - Do not perform table validation.
Now the table can be opened, you need to reset the header record count to the correct value.

If it doesn`t work, you may recover it with help of third-party program, for instance Recovery Toolbox for DBF https://dbf.recoverytoolbox.com/

Feb 03, 2015 | Microsoft Visual FoxPro 9.0 Professional...

1 Answer

Please give me the procedure how to import foxpro files in tally 7.2


To import data from a FoxPro database, use the Microsoft Visual FoxPro ODBC driver. To do so, follow these steps:
1) Click Start, and then click Control Panel.
2) In Control Panel, double-click Administrative Tools.
3) In the Administrative Tools window, double-click Data Sources (ODBC), and then add a new ODBC data source for your FoxPro database or tables by selecting the appropriate Visual FoxPro driver.
4) Start Access, and then open your Access database. 5) On the File menu, point to Get External Data, and then click Import. 6) In the Import dialog box, click ODBC Databases in the Files of type list. 7) In the Select Data Source dialog box, click the Visual FoxPro data source that you created in step 3, and then click OK. 8) In the Import Objects dialog box, click the tables that you want to import, and then click OK.

Jul 05, 2010 | Computers & Internet

4 Answers

HOW TO SOLVE VFP FILE CURRUPT WHEN POWER FAILURE


At times, you may view that your MS Visual FoxPro 9.0 database is behaving abnormally. Some of the abnormal symptoms could be an error message while opening any database table, invalid characters in place of pre-defined values, and and more. The main reason for abnormal behavior of the database is its corruption due some logical crash. Few common reasons for corruption of MS Visual FoxPro 9.0 database are abnormal termination, faulty network devices, simultaneous modifications, conflicting third-party software, and incompatible service packs.
To overcome such database corruption scenarios, the user can use an up-to-date backup and perform restoration. However, restoration fails in cases where the user either forgets to create a database or the database backup itself gets damaged. In such cases, the database users can use a third-party DBF File Repair application to repair his/her corrupted database.
To illustrate the above case, consider a real-time scenario wherein you execute a query to modify your MS Visual FoxPro 9.0 database. While the query was performing the modification, the system shutdown due to power failure. However, the next time you tried to mount the database, you encountered an error message that did not allow you to access the database records. Moreover, the same error message appears every time you try to access the database.
Cause:
The root cause for the error message is MS Visual FoxPro 9.0 database corruption due to improper system shutdown.
Resolution:
The database corruption error message can be surmounted by following the below steps:
Use a complete database backup and perform restoration. However, in case of database backup unavailability, you will need to search for a commercial DBF File Repair utility.
A third-party DBF Repair application uses effective repair techniques to repair logically damaged MS Visual FoxPro 9.0 database and restore it at a new and safe location. The original database during the repair process remains intact. The tool is easy-to-understand and allows even a non-technical person to perform repair.
DBF Recovery Software is a comprehensive solution to repair databases created in MS Visual FoxPro 9.0, MS Visual FoxPro 8.0, and MS Visual FoxPro 7.0. The tool also repairs databases built in dBase III, dBase IV, and dBase V. Supported by Windows 7, Vista, 2003, XP, and 2000, the DBF Repair tool creates a new repaired file that can be attached to existing database.
Tanvi Sharma is a self employed Internet entrepreneur and product reviewer. This DBF Repair utility is extremely useful when the dBase and Foxpro database gets corrupted due to internal program errors, hardware malfunctioning, accidental deletion of data and more. This DBF Repair software repairs all types of database components including table name, column name, column data type, indexes and primary keys.

May 31, 2010 | Microsoft Visual FoxPro Professional...

1 Answer

My exel file change become MENC file, how can I Convert to exel again


Just edit the filename to the original name.

Example

myexcelfile.xls

Jun 05, 2009 | HTC Touch Viva Cell Phone

1 Answer

Import .dbf file format to tally 7.2 file format


Exist some tools for solving like issues, and to my mind one of them might be able to help in like situation. I found out one of them on an one soft forum - dbf recovery.

Mar 01, 2009 | Tally T2245 Matrix Printer

1 Answer

I want connet foxpro databse to visiual basic


Using a DSN-less connection to open a free table
'
cn.Connect = "SourceType=DBF;" _
& "SourceDB=C:\Vfp\Samples\Data;" _
& "Driver={Microsoft Visual FoxPro Driver}"

Jan 20, 2009 | Computers & Internet

2 Answers

Convert my database from dpf to mdb


Use access to import external data. It can read dbf and create mdb

Jan 06, 2009 | Microsoft Visual FoxPro Professional...

2 Answers

Visual foxpro to access


hi
you need to use a ODBC conexion to trasport your tables into table .dbf in fox

or

you need to copy tur tables to excel documents an then import in vfp

bye

Jan 05, 2009 | Microsoft Visual FoxPro Professional...

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

215 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18355 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...