Unanswered

How to turn off data type detection in SQL instructions?

(0) Share

Report

Posted on by franco2

I'm making a SQL query to an Excel file ,the data is not well defined inside the file. If is possible I would like to set my data type to "any" so it takes the data just how it is inside the file.

Just to put an example of what is happening. In the excel file I have data set like this:

- 0321

- 73,0000

- 03:00:01

And when queried to a data table it changes:

- 321

- 73

- 3:00:00

Thank you

Categories:

Power Automate Desktop

All responses (5)

Answers (0)

Sort by

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@franco2
Could you please share screenshot of your table with some row values(with column names with datatype) and hide if any sensitive info?
franco2 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Here is the SQL instruction:
Now I just noticed that the data inside the tables are ok, but is when I write them to a new excel file- is when it changes.
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@franco2,
Thanks for the details. However, I am seeking a screenshot of an SQL data table displaying some values along with their respective column data types. This will enable me to replicate a similar issue in my system and attempt to assist you with it.

Sample screenshot for your understanding:
franco2 33 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, here I got some screenshots.
Data in Datatable of power automate:
Data in origin excel file:
I checked the data type of the origin excel file and is set to date.
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@franco2
Could you kindly provide additional screenshots that include the details referenced in your post (0321 - 73,0000 - 03:00:01)? Also, please specify the data types displayed in the Excel file for those values? pls.

This information will help us analyze the issue further and offer potential solutions.