I found these instructions at the Microsoft Support Site at:
http://support.microsoft.com/default.aspx?scid=KB;en-us;q225861
I have copied the pertinent part below. PLEASE LET ME KNOW if this is
confusing or difficult, if it is I will go ahead and create the
utility to make a memo-less copy of Albums for Access 2000 ("Notes" is
the memo field in the Albums file, by the way). If I don't hear from
you, I will assume the information below is sufficient and won't
create the utility. As I said before, I don't have a copy of Access
2000 so can't evaluate it myself. Thank you very much for alerting me
to this problem with Access2000, and here are the Microsoft
instructions:
ACC2000: No Option to Import, Link, or
Export to the FoxPro File Type
The information in this article applies to:
Microsoft Access 2000
This article was previously published under
Q225861
This article applies only to a Microsoft
Access database (.mdb).
Moderate: Requires basic macro, coding, and
interoperability
skills.
SYMPTOMS
In the Import, Export, and Link dialog boxes
in Microsoft
Access 2000, FoxPro is not listed as an option
for file type.
CAUSE
The Microsoft FoxPro ISAM driver is no longer
included with
Microsoft Access.
RESOLUTION
To import from, link to, and export to
Microsoft FoxPro, use the
Visual FoxPro ODBC driver, as demonstrated in
the following
steps.
Import from FoxPro
Click Start, point to Settings, and then
click Control
Panel.
In Control Panel, open the ODBC Data
Sources (32-bit)
tool, and add a new ODBC Data Source for
your FoxPro
database or tables by selecting the
appropriate Microsoft
Visual FoxPro driver.
Open the Access database that you want to
import into.
On the File menu, point to Get External
Data, and then
click Import.
In the Import dialog box, click ODBC
Databases in the
Files of type list.
In the Select Data Source dialog box,
select the Visual
FoxPro data source that you created in
step 2, and then
click OK.
In the Import Objects dialog box, select
the tables that
you want to import, and then click OK.
========= end of article abstract
Robert R. Borrell
HighRoad Software
--- In CDCzar@yahoogroups.com, "regstration <regstration@y...>"
<regstration@y...> wrote:
> Hi,
>
> I am plinking around with CDCzar and like what I see! One attractive
> feature is (potential?) accessability from Access. I can link to the
> Artists and Tracks table but not the Albums table. I have tried all
> avaliable formats but the message is the same: "External table is
not
> in the expected format." What gives?
>
> -Don