Search results

Ok thanks, i am, going to use the robocopy and run from a bat file as think that's much Easy to do thanks anyways

Hi so i am looking for a way to automate copying file from a network folder to a local folder, using say a table that logs the last file date copied? was thinking FileCopy "some_network_drive\*.txt", "C:\importing\" but this wouldn't copy the last few days but all in folder so guessing i...

Hello, So i need to have the query show one line per customer order, the fields i have are as follows Order_Date Order_Number Product_ID results i see is Order_Date Order_Number Product_ID 25/06/2024 592572 RRW01 25/06/2024 592572 RYTA02 i would like to see then...

Running well now thank you :)

thanks also had to change With .OpenTextFile(path, 2) to With .OpenTextFile(col(j & ""), 2) running now...

setup the table as you have suggested and started the job it imported all the files within the first folder and deleted them as planned and it threw up this error... if i now try to start the job again its says..

Thank you yes that worked, so now for a different question, i also have to import other text files they are in a folder and has then a folder for each day, folders are named as the date like this 2024-01-31 and contain 2-3 files in each folder how's best to get these to import in bulk too ?

Thanks added that getting another error now on

Ok thank you for sharing, i am getting a run time error using this code..

I am looking for a better way to import txt files rather than me having to select the file and then import all the files are within 1 folder

Thanks all i got it working using RealDate: DateSerial(Left([T_Date], 4), Mid([T_Date], 5, 2), Right([T_Date], 2)) 20231130 = 30/11/2023 :)

Hwllo, so i am trying to confirm a date string and format as date 20231129 would be 29/11/2023 what's the best way to confirm via query

I am trying to get this working i have a pivot that is showing at the moment three month columns. I want to count the number of rows within the pivot that have data which is a number =COUNTIF(Q10:Q150000, "<>")-1 (i am using the 1- top removed the pivot totals) =COUNTIF(R10:R150000, "<>")-1...

ok thanks got it working now using AccountRef: Mid([Account_No],5)

Thanks how would i use this in the query?

Its always the same and position

Hi So i need to remove the prefixed number from "ACC/0014471211" to "0014471211" whats the best way to do this with a query?

how do i copy this formula to all rows =COUNTIF(A:A,A112911) if i drag it it changed the row number =COUNTIF(A:A,A112912) =COUNTIF(A:A,A112913) =COUNTIF(A:A,A112914) =COUNTIF(A:A,A112915) and so on..

Thanks all so i have now imported the file and have set the specification imported a test file and looks good so thanks got it sorted now for the formatting :)

around 350k