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.super news.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_djsteel e@NOSPAM_canada .com> wrote in message
news:gn******** ******@news04.b loor.is.net.cab le.rogers.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.supe rnews.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
