Inserting to SQL via Access
Posted on 2008-11-17
I have a seemingly simple problem:
I have an Access database table which is populated via integration with
small-parcel tracking information.
The table has four columns: Order Type, Order Number, Tracking Number, and a Timestamp (Access gen).
What I need to do is write a Query that takes this table and inserts only the tracking numbers from the last 12 hours into a SQL Database table available to Access via ODBC.
The real issue I am having trouble with is the Timestamp filter.