>i have a dbc and want to export a few tables into sqlserver express with the data attached.
>in vfp the PK was handled by an insert trigger in SQL i want to use the auto-incrementing feature
>can that be done and if yes HOW?
>
>Next I need to create an access front end. possible??
>
>thanks
>
>Peter
SET IDENTITY_INSERT TableName ON
insert rows
SET IDENTITY_INSERT TableName OFF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.