By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,323 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

MS Works 6.0 to Access 2000

P: n/a
MS Works 6.0 to Access 2000. Tried saving to *.csv and dbf as well as
converting to Excel then loading but to no avail. My Works database has
about 4000 records, each with about 30 fields. Is there a way to convert to
Access without re-entering the information 1 record at a time? TIA
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
What happened when you tried saving to .csv or .dbf, and when you went
through Excel?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Tlaker" <dp***@localnet.com> wrote in message
news:10*************@corp.supernews.com...
MS Works 6.0 to Access 2000. Tried saving to *.csv and dbf as well as
converting to Excel then loading but to no avail. My Works database has
about 4000 records, each with about 30 fields. Is there a way to convert to Access without re-entering the information 1 record at a time? TIA

Nov 13 '05 #2

P: n/a
Saving as .dbf, I get "Microsoft Jet Database Engine could not find the
object 'name.dbf'" even though I browsed to the folder and clicked on it.
Saving as Excel worked but only as a link to Excel and not as an Access
table. Saving as .csv shows a table as a link to Notebook, again not as an
Access Table.

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:gn**************@news04.bloor.is.net.cable.ro gers.com...
What happened when you tried saving to .csv or .dbf, and when you went
through Excel?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Tlaker" <dp***@localnet.com> wrote in message
news:10*************@corp.supernews.com...
MS Works 6.0 to Access 2000. Tried saving to *.csv and dbf as well as
converting to Excel then loading but to no avail. My Works database has
about 4000 records, each with about 30 fields. Is there a way to
convert to
Access without re-entering the information 1 record at a time? TIA


Nov 13 '05 #3

P: n/a
What did you attempt to do with the .dbf file? Open it, or import it? You
can't open a .dbf file in Access: your only choices are to import it, or
link to it (through File | GetExternal Data). If that's what you did, what
was the actual name of the dbf file? I believe there's a restriction that
the name must conform to the old 8.3 rules (no longer than 8 characters
before the period, and no spaces)

I'm not sure I understand your comment about what happened when you saved it
as Excel, but again, if you want to use it inside of Access, you must either
import it or link to it.

You may have got the drift by now that you're going to need to link to or
import the .csv file.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Tlaker" <dp***@localnet.com> wrote in message
news:10************@corp.supernews.com...
Saving as .dbf, I get "Microsoft Jet Database Engine could not find the
object 'name.dbf'" even though I browsed to the folder and clicked on it.
Saving as Excel worked but only as a link to Excel and not as an Access
table. Saving as .csv shows a table as a link to Notebook, again not as an Access Table.

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:gn**************@news04.bloor.is.net.cable.ro gers.com...
What happened when you tried saving to .csv or .dbf, and when you went
through Excel?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Tlaker" <dp***@localnet.com> wrote in message
news:10*************@corp.supernews.com...
MS Works 6.0 to Access 2000. Tried saving to *.csv and dbf as well as
converting to Excel then loading but to no avail. My Works database has about 4000 records, each with about 30 fields. Is there a way to

convert
to
Access without re-entering the information 1 record at a time? TIA



Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.