Foxpro Database related  
Author Message
SmileSmita





PostPosted: Visual FoxPro General, Foxpro Database related Top

Hi there,

I wanted to quickly know how i can convert foxpro database into Access DB Do i loose any data or indexes or anything once i transfer the database from foxpro to Access

Please let me know.

Thanks,

Smita




Visual FoxPro2  
 
 
Dave M.





PostPosted: Visual FoxPro General, Foxpro Database related Top

In Ms Access

File>get external data>Import

Yes you will loose the indexes you will need to create new indexes in Access.

If you use File>get external data>Link tables

The data will stay in the DBF but be accessible from Access as if it where an Access table. The Indexes will be maintained.

Dave M.



 
 
Docpro777





PostPosted: Visual FoxPro General, Foxpro Database related Top

I wanted to quickly know how i can convert foxpro database into Access DB Do i loose any data or indexes or anything once i transfer the database from foxpro to Access


As per David M., and ...

You might test with: Memo fields, General fields, Structural indexes, Candidate indexes etc.