I wish to import my ms works databse file into ms office excell

G

Guest

I would like to import my MS WORKS database file into Excell. Any
suggestions. Thanks in advance. Fran Meyers
 
6

'69 Camaro

Hi, Fran.
I would like to import my MS WORKS database file into Excell. Any
suggestions.
Click to expand...

This isn't an Excel newsgroup, so you can't expect us to know how to use
Excel to import file formats from anything but Microsoft Access databases,
which this newsgroup is dedicated to.

However, you can open the database in Works and select the File -> Save
As... menu, then select the "Save As Type" combo box and choose "Text &
Commas (.csv)," then navigate to the directory you want to save the file and
press the "Save" button. Open the resulting .CSV file in Excel, and you now
have a spreadsheet. You can convert it into an XLS file with Excel if you
need to save formatting and formulas and such.

Any further Excel questions should be posted in an Excel newsgroup, so that
you can get better and quicker answers from the Excel experts.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

import data from db2 database to ms office access 2007 1
Automating Excel Data Import 8
can't import data excel spreadsheet 3
Empty Rows 3
Importing from a excel file from a spasific Worksheet 1
Excell t Access 2
How to export table from outlook into ms access table? 0
error message importing from excell to access 1

Top