Wrong data types when loading sql query with vba in excel

Question

I have a SQL Query, which I want to use in VBA to load the data into Excel, the problem is that when the load is done the data in Excel is with the wrong type. For example, where it needs to be a date, it remains an integer, where an integer is a date. Is there any way to fix this? Example my query:

sql = " SELECT DATA, ITEM, COMPANY, SALES FROM SALES "

Format the date column afterwards with something like Range("A:A").NumberFormat = "dd/mm/yyyy" — braX
– braX, Commented Jan 31, 2020 at 11:03

Naveen Kumar · Accepted Answer · 2020-01-31 11:03:23Z

2

You will have to format cells as per date format. Also ensure that values are correct in your query output.

Sheet1.Range("A2", "A100").NumberFormat = "yyyy-mm-dd"

answered Jan 31, 2020 at 11:03

Naveen Kumar

1,9961 gold badge9 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Wrong data types when loading sql query with vba in excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related