Yes, you can. See info from MS Access Help pasted below (this is Access
97).
>-----Original Message-----
>From: Peter Benoit [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, October 05, 2000 9:44 AM
>To: CF-Talk
>Subject: linked table
>
>
>Thought I'd ask ya'll before attempting this myself... but can I link a
>foxpro DB to my access DB, and then use it in CF?
>
>Thanks,
>Pete
>
Import or link Microsoft FoxPro or dBASE files
You can import or link .dbf files in Microsoft FoxPro 2.x, and dBASE
III, IV, or 5 formats. You can also import, but not link FoxPro 3.0
(.dbc) format.
1 Open a database, or switch to the Database window for the open
database.
2 To import files, on the File menu, point to Get External Data, and
then click Import.
Show me
To link files, on the File menu, point to Get External Data, and then
click Link Tables.
Show me
3 In the Import (or Link) dialog box, in the Files Of Type box, select
one of the Microsoft FoxPro or dBASE file types.
4 Click the arrow to the right of the Look In box, select the drive and
folder where the .dbf file is located, and then double-click its icon.
� If you're importing, Microsoft Access creates a table named after the
file you selected and imports the data from the .dbf file. Go to step 7.
� If you're linking, Microsoft Access displays a dialog box where you
can associate FoxPro or dBASE index files. Go to step 5.
5 Double-click each FoxPro index (.idx or .cdx) file or dBASE index
(.ndx or .mdx) file you want to use, and then click Close. If there are
no indexes, click Cancel to continue.
6 In the Select Unique Record Identifier
dialog box, select an index that uniquely identifies each record. This
index must contain no duplicate values, or Microsoft Access might not be
able to properly update data in queries with joins.
7 If you want to import or link another FoxPro or dBASE file, repeat
steps 4 through 6.
Notes
� After importing or linking a .dbf or .dbc file, you can set field
properties for the table. If you import a .dbf or .dbc file, you might
also want to set a primary key for the table. For more information,
click .
� If you link a .dbf file and associate an index (.idx, .cdx, .ndx, or
.mdx) file, Microsoft Access needs the index file in order to open the
linked table. If you delete or move FoxPro or dBASE index files or the
information (.inf) file that Microsoft Access creates, you won't be able
to open the linked table.
� When you use Microsoft Access to update the data in your .dbf file, it
updates the index files to reflect your changes. If you use FoxPro or
dBASE to update data, you must update the associated indexes within
FoxPro or dBASE as well. Microsoft Access can't use a linked table if
the indexes you specified aren't current.
� If your FoxPro or dBASE tables are stored on a read-only drive or
CD-ROM, Microsoft Access can't create an .inf file in the same folder as
the .dbf files. To link a table on a read-only drive, place the .inf
file on a read/write drive. You can specify the path of the .inf file in
the Windows Registry. For more information, click .
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
