Search the web
Sign In
New User? Sign Up
CDCzar · CD Czar Music Collection Manager
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Importing/linking data into MS Access   Message List  
Reply | Forward Message #54 of 115 |
Re: Importing/linking data into MS Access >>>UPDATE<<<

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




Tue Feb 25, 2003 12:28 am

jockamo2001
Offline Offline
Send Email Send Email

Forward
Message #54 of 115 |
Expand Messages Author Sort by Date

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...
regstration <regstrat...
regstration
Offline Send Email
Feb 23, 2003
7:05 am

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...
jockamo2001 <highroad...
jockamo2001
Offline Send Email
Feb 25, 2003
12:28 am

Hi Robert, I was able to link to Albums.dbf using the "Visual Foxpro Tables" Machine Data Source and selecting the ID field as the unique identifier. The...
regstration <regstrat...
regstration
Offline Send Email
Feb 26, 2003
3:45 am
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help