Can I use MS Works files with BrokerForce™?

If a manufacturer wants to send you data and has Microsoft Works, following are any of the file formats that they can save the file to and send you to use for importing their data.

Works Spreadsheet can save a worksheet in any of the following files:

• Works 6.0 Spreadsheet (.xlr) files.
  
  NOTE: This is the Microsoft Excel native format.
  
• Works for Windows 3.0 Spreadsheet through Works 2000 Spreadsheet (.wks) files.
  
• Works for Windows 2.0 and Works for MS-DOS Spreadsheet (.wks) files.
  
• Unformatted comma-delimited text (.csv) files.
  
• ASCII unformatted tab-delimited text (.txt) files.
  
• Excel 4.0 through 2000 (.xls) files.
  Microsoft Excel can open and view a Works Spreadsheet document in its native (.xlr) format. A Works Spreadsheet document can be viewed with any program that can open or view a Microsoft Excel worksheet.

Microsoft Works Database:

Works Database can save a database in any of the following files:

• Unformatted comma-delimited text (.csv) files.
  
  
• ASCII unformatted tab-delimited text (.txt) files.
  
  
• DBase III and dBase IV (.dbf) files.

To Convert a Works for Windows Database to Excel 

1. Open the database in Works for Windows.
   
2. On the File menu click Save As.
   
3. Under Save File Format, click dBASE IV.
   
4. Click Save.
   
5. Start Excel.
   
6. On the File menu, click Open.
   
7. Under Files of Type, click dBase Files.
   
8. Locate the file you exported from Works and click Open.
9. Save the file to an Excel, csv, or tab delimited format for import into BrokerForce™.
   

For more information click here

Return to FAQs

Home  Order BrokerForce™  FAQs  Data Request  Download  Demos  Account Maintenance  Contact

Copyright©1995 - 2008 DataForce, Inc. Patent 6,901,380 and Patents Pending