SQL Server Timestamp to Access Text field
$30-250 NZD
Πληρώθηκε κατά την παράδοση
Currently I have a Python script that uses ODBC to transfer data from SQL Server to Access. I now need to remove the Python script and handle the data load from Access.
With ODBC it must truncate the Timestamp value before inserting into Access. The reasoning for this is that 90% of the Access rows have the same value.
SQL Server (Timestamp) Access (Text 50)
0x000000000189CF01 003F49
0x000000000189D001 003F69
0x0000000001B54DFF 003F6D
0x0000000001F74701 003F4E
0x000000000189C003 003F70
The Access value is retrieved for the rows using the below:
Hex(Asc(Mid(Stamp,1, 1))) &
Hex(Asc(Mid(Stamp,2, 1))) &
Hex(Asc(Mid(Stamp,3, 1))) &
Hex(Asc(Mid(Stamp,4, 1)))
As the Access column is Text 50 I have loaded the text representation of the timestamp value i.e.:
0x000000000189CF01
0x000000000189D001
0x0000000001B54DFF
0x0000000001F74701
0x000000000189C003
I now need an update statement to convert it into the exact same value that ODBC uses so that when I do the select it comes out as:
003F49
003F69
003F6D
003F4E
003F70
Ταυτότητα Εργασίας: #18345517
Σχετικά με την εργασία
6 freelancers κάνουν προσφορές κατά μέσο όρο $139 για αυτή τη δουλειά
Hi, I'm a senior Ms Access, SQL Server and VBA developer. I have read your project description and I'd like to help you with what you need. However, I need more explanation as I don't know exactly what you mean by tha Περισσότερα
Hello I am working with MS-Access database and VBA for the past 18 years. I have also developed many important application using MS-Access as both front-end and back-end tool and have completed a good number of Acce Περισσότερα
Hi... How are you?. I saw your description carefully and i 'm very interesting your project. And i can start to work just now and will be my best to finish asap with good quality. But to do your project perfect Περισσότερα
Hi, I'm a DB expert from Bulgaria(EU) with strong experience in wide variety of RDBMS: MySQL, PostgreSQL, MS SQL Server, Oracle, Teradata and a few others.. I have a solid knowledge in writing and tuning complex Περισσότερα
Hello, I have worked 3.5 years with SQL Server building models and queries for reporting. I believe that your request is really clear with a few examples of results from the data provided. I am curious of the wa Περισσότερα
Hi sir. i am a python expert. and i have a good experience in sql. so i hope you will work with me. thanks.
