SQL Server Timestamp to Access Text field

Sedang Disiapkan Disiarkan 5 tahun lepas Dibayar semasa penghantaran
Sedang Disiapkan Dibayar semasa penghantaran

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

Microsoft Access Pelayan Microsoft SQL SQL

ID Projek: #18345517

Tentang projek

6 cadangan Projek jarak jauh Aktif 5 tahun lepas

6 pekerja bebas membida secara purata $139 untuk pekerjaan ini

alaeddindhahri

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 Lagi

$166 NZD dalam sehari
(72 Ulasan)
5.9
KellogITSolution

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 Lagi

$61 NZD dalam 7 hari
(29 Ulasan)
4.6
crocodile305

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 Lagi

$112 NZD dalam 3 hari
(0 Ulasan)
0.0
veskojl

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 Lagi

$250 NZD dalam 3 hari
(0 Ulasan)
0.0
JCGauvreau

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 Lagi

$90 NZD dalam 3 hari
(0 Ulasan)
0.0
hunmin888

Hi sir. i am a python expert. and i have a good experience in sql. so i hope you will work with me. thanks.

$155 NZD dalam 3 hari
(0 Ulasan)
0.0