Formatting in MS Access

I am trying to format a Access table fields to include all values as in the images below. However when I copy and paste from excel to the Access table, only significant figures appear in the table. …

Python/Excel/SQL column dates to exploded rows

I have an Excel spreadsheet table like this where it shows how many units were sold each week for 2019 and 2020 (columns) and I am trying to put it into an access database formatted like the second …

How can I create a column with time HH:MM from a timestamp column with time HH:MM:SS in my dataset [closed]

How can I create a column with time HH:MM from a timestamp column with time HH:MM:SS in my dataset

Joining on 3 csv files

I need to retrieve data from 3 different CSV files (Adres.CSV, ID.CSV and Regios.CSV) and combine this in an Excel table. This SQL statement works fine, StrSQL = “SELECT ID.[ID], Adres.[Naam], …

Wrong data types when loading sql query with vba in excel

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,…

Is there a way to count all the trailing zeros in a column in MySQL?

I am looking to find out if there is a way to count the number of trailing zeros in a column. The column is made up of a maximum of 13 numbers as shown below and I want to count all the zeros before …

bad date format for pivot

together I can not figure out why in PowerPivot or Excel a Microsoft query does not provide the date fields in the format for Excel as they are necessary. I have already gotten from you in another …

Translate Excel business logic to T-SQL

I need to ‘translate’ some business logic from Excel to T-SQL, I’m having a hard time with it. It’s about figures from gates that count how many customers go IN and OUT of the stores. All DATA you …

‘CREATE TABLE’ generates Run-time error ‘3290’

I have a syntax issue in the first CREATE TABLE statement. I’m receiving the following VBA error: Run-time error ‘3290’ The goal is to move the distinct data to a new table dependent on values in …

Transfering Data with VBA(Excel) to SQL Server but avoiding duplicate column?

My main objective is to transfer some data from excel to SQL server while using vba but in the process I would like to detect and avoid transferring some duplicate month columns. This is what i have …