I'm trying to take all txt files in a folder and convert them to excel files. I 'borrowed' the below code and it seems to work EXCEPT that it only does text to columns on the header line. (Be gentle - I so appreciate all your expertise, but I'm really not great at this... Any help is...
Hi Gasman,
I did see the link DBguy posted (thank you both). I tried to incorporate that into my code, but it didn't work. Either way - I can't seem to make it work. Apologies - I am a very new to VB and SQL - come a long way - but still get tricked up on some of this as I don't use it...
It does not seem to recognize FileDateTime
Dim ImportDir As String, ImportFile As String
ImportDir = "G:\Connecticut Children's Care Network\Payer Relations-Contracting\Payer Data Files\Connecticare\"
ImportFile = Dir(ImportDir & "CCI_CCMC_MULTI_ERDLYRPT_BU_FD01_PROD*")
Do While...
Thank you. One additional question. I would like to include the excel creation date (the date that excel file was created) in another field.
Same concept, but I can't find what to call the field that Access will recognize to pull in this date.
Thank you all. I modified and it brings in a filename, but it lists the LAST file name it imports for ALL the records, instead of the each file name that it pulls in. (pulling in data from several different files).
Dim ImportDir As String, ImportFile As String
ImportDir =...
The below gives me "Syntax error in UPDATE statement"
Private Sub Command6_Click()
Dim ImportDir As String, ImportFile As String
ImportDir = "G:\Connecticut Children's Care Network\Payer Relations-Contracting\Payer Data Files\Connecticare\"
ImportFile = Dir(ImportDir &...
I have this code which appropriately imports all files from excel in a folder with a certain wildcard name:
Private Sub Command4_Click()
Dim ImportDir As String, ImportFile As String
ImportDir = "G:\CCC\Payer Relations-Contracting\Payer Data Files\Connecticare\"
ImportFile = Dir(ImportDir &...
I have a database with about 5 users - all have personal front ends, linked to the shared back-end table database.
Everyone is able to access fine, except one - who gets the error "could not lock file" on opening.
I do NOT want her to try and open in Exclusive mode - as the fix code to the...
Do you mean to mirror change the name of the path to mirror how Access would read it? Access reads dates as long format and you cannot name a path with "/"
But on that same note, wondering if one of the file paths has a date?
The file path is = "G:\CLASP\CLASP Committee\2022 meetings\8-8-2022"
The field [PH-ISAC] is a date field 8-8-2022.
I have the date field in access formatted exactly as the file path above, but somehow it is not accepting...
Thank you all for your suggestions. Still does not seem to work. If I name the file just RG_ and guideline name (i.e., RG_Anemia), it finds the file, however if the file is named "RG_Anemia 8.17.22", it does find it.