interesting way of doing it. Thanks.

Well I see you know GPS.  Basically the informatin is more or less in a CSV string very similar to the raw NMEA.

I have a "work" table that I insert...

I need a high performance - initially 14 entried per second.

Year on 70 entries per second.

I heard I could look at writing a trans/comment state that would do it but...

Access on its own runs into problems if it grows to 1GB.

How are you connecting to the SQL Server?

What is the security mode on SQL Server? Windows only or mixed?

Anything in...

I don't believe there is any settings.  If you insert data its appended.

You could write soem VBA code to open the file, read the first line, check it its an...

BCP?  I'm don't know term

So I take it that you would use XML for interfacing with a web site?

Jim