prevent sqlwrite from rounding numbers

Hi everyone! I'm trying to write a table into a Access-database using sqlwrite and I have two problems.

1. Part of the table is a UNIX-timestamp which looks like this in the table: 1.570555200000000e+09 (Well it looks like this: 1.5706e+09 before double clicking it).

After the export to Access using sqlwrite it looks like this in the database: 1570560000

But it should look like this: 1570555200.

How can I prevent rounding the number? Rounding destroys the timestamp.

2. The rest of the table are numbers. After the export to Access they have different numbers after the point. Some have two and some have three numbers after the point.

Is it possible to specify the numbers after the point?

Many thanks in advance!!

Answer 1

[Kiran Felix Robert]

Hi Jan,

To avoiding rounding and data truncation by sqlwrite you can store the data as a string. This will also preserve the precision.

Kiran Felix Robert

[Luke Simonson]

Is there an alternative to this? This doens't work properly when the database table already exists with number formats on specific columns.

I have a specific task where I am reading data from an SQL table, making some changes to a 4 columns (out of ~60 columns total) and rewriting them to the same table (appending new entries). However, many of the numberic columns are slightly off due to rounding.