Recent content by StuartBowen

apologies, undertsood. dont have any links to the site, it just got me out of a hole

btw this large csv which contains all data from all files, including those that failed with the 'specification doesnt exist' error, is being imported using the same transfertext line of code using the same specification

decided to pick my battles since this made zero sense. I now use [REDACTED] to merge my several dozen identical format csv files into one and just have some code to import, run a delete query, then append query and finally delete the temp table and csv file. EDITED BY The_Doc_Man to remove...

I altered so that it runs and as soon as it is successful in importing one file, it exits. Intention was to see if it was the fact it was importing a second file. It imports the first then exits. I click the button to import again, it doesnt import the first company file because the file doesnt...

just did a switcheroo. I swapped the names on the files so the 82 record import went first. It was fine. Then went to import the 8 record file. it errors. This file was fine two minutes ago.

thought I would reboot PC but still same. So just run again, first file went fine with only approx 8 records. Second one did the thing where it actually imports the 82 records, but errors with the import specification error on the delete query line.

this is the code in question As mentioned, I have suspected the content of the particular csv but it has just imported fine, content of M365Temp table looks good, no import errors and yet it fails with the same error on the following delete query. Also, if I do a manual import using the same...

Quick update, I moved the location of the files to c:\CIPP\ so outside SharePoint. I run now and one of the files it struggled on, it runs the problem code, imports the file into M365Temp (definitely there) goes on to a delete query, asks if I would like to delete, I click yes and it then comes...

OK. Banging my had for hours now. I am doing something exceptionally simple yet it fails. I am importing some data in various CSV files in a loop into Access, and all CSV files have the same format. I need to check a file exists for a client (filename is in format domainname.co.uk-Users.csv...

Thanks and currently working round using NZ but don't want to, since it only affects the one computer. The ODBC settings on that computer are the same as mine and mine displays zeros not nulls.

Hi I have a client who is connecting a Mac running parallels with Windows 10 Pro and Access as part of Office 365 on latest updates. He is connecting to an SQL 2012 database via ODBC. The issue us that if the table has a zero in a field, the data is presented as a null in the linked Access...