Still battling away with this.... latest query is:

DECLARE @filepath varchar(100) = 'C:\SQLData\WRsales\'
,@pattern varchar(100)= 'Waitrose_PerformanceAndLoyalty_*.txt'
,@tableName varchar(100)='dbo.SalesHistory'

DECLARE @query varchar(1000)
DECLARE @numfiles int
DECLARE @filename varchar(100)
DECLARE @files TABLE (SourceFileName varchar(200) NULL)

SET @query...

Hi Jeff, thank you so much for your replies, I'm just working through them now!

The files are stored on the C drive of the server at the moment: (the client...

Hi, good spot for the decimal places, I've added this into the Margin column. Rounding to 2dp is sufficient for now, and I'll actually be dropping all of the columns...

Here is the Create Table Query, incase it should be useful...

USE [DBName]
GO

/****** Object:  Table [dbo].[SalesHistory]    Script Date: 10/02/2023 16:16:45 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER...