SQL Server Timestamp to Access Text field

In Progress Posted 5 years ago Paid on delivery
In Progress Paid on delivery

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 Microsoft SQL Server SQL

Project ID: #18345517

About the project

6 proposals Remote project Active 5 years ago

6 freelancers are bidding on average $139 for this job

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 More

$166 NZD in 1 day
(72 Reviews)
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 More

$61 NZD in 7 days
(29 Reviews)
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 More

$112 NZD in 3 days
(0 Reviews)
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 More

$250 NZD in 3 days
(0 Reviews)
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 More

$90 NZD in 3 days
(0 Reviews)
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 in 3 days
(0 Reviews)
0.0