>>Hi all, I have a large meeting soon where attendees can check in at four different access points, when check in is complete I need to merge all attendees into one master table, unfortunately it isn't feasible to set up any kind of network because of security regulations at the site. Is this achievable using SQL Server express ? . My thinking is to nominate one workstation as the *master* and import the check in data from the other three on completion. It's not an ideal situation I know but my options are limited. ( ALL SUGGESTIONS WELCOME )
>
>You can make your PK using a short prefix + sys(2015), or a GUID. In case of prefix, you'd assign each WS one, so any record would have its WS of origin as a key. And add datetime fields to all tables, to update on save (maybe you could use timestamp datatype, if you would care to map them to something usable on VFP side). Then you'd append whatever isn't in the tables, and overwrite whatever is but has a fresher time.
>
>The schema of who gets what is, generally, everybody gets everything. You export whatever is new since your last export, regardless of origin. So you may be exporting something you just imported, but at least you won't miss anything and things won't get too complicated. Under complicated I mean "record on WS1 which came from WS2 but was edited on WS3 - now do I export it from WS1 regardless, or do I keep tabs on records I created/updated and export them only". If you have an audit log, however, then you are done with the complicated part: you can just go through it and select any records mentioned in it since the last export.
>
>If your security allows, you can just do two rounds with a flash drive around your machines, each one exports what it has, imports what it finds, and that's it.

Hi Dragan, thanks for your time, it will be a one-off export from three machines to one *master* it's how to do the export / import I'm not clear on e.g. do I export to text files / Excel ??? I'm not au fait with SQL Server export import ( I will be using the free version )

Edit

This has to be done using .NET and SS no foxpro for years now :-(