| Cindy Winegarden 2005-07-15, 1:24 pm |
| Hi Attila,
You could do an SQL Select of the data to change the field names/types/sizes
and then append that to a remote view (using ODBC) of your Access table(s).
--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
<adobozi@telus.net> wrote in message
news:1121356069.983328.99490@g47g2000cwa.googlegroups.com...
> Hello,
>
> I need to insert a lot of records from a VFP9 database into an MS
> Access database. The process will run on a timer (nightly) to update
> the MS Access database.
>
> I started coding by opening the MS Access database through OLEDB but
> could not figure out how to create the INSERT command that would copy
> the data from the VFP database into MS Access. I would prefer not to
> SCAN the VFP tables and use indivual record INSERTS into MS Access
> because I think it will take too long.
>
> The process has to be automated so I can't use the MS Access
> File->import menu.
>
> The database schema is different between the two databases (diff table
> names and diff field names).
>
> Has anyone done something similar?
>
> TIA
> Attila
>
|