Recent content by mims

thank you SO much! its working perfectly now!!! really appreciate your help - it has saved me hours and a lot of frustration. :)

hi, thanks for your reply. There does not seem to be a problem with the first row of data, because if i put a blank line in the first row then it is picked up correctly. Its seems that the file is only being read from the 2nd row of the text file downwards. Any idea why this could be? i am...

Hi, I am using VBA code to upload a text file into an MS Access table (see code below). Everything is working fine, but the first line of the file is not being uploaded. It imports line 2 onwards. Does anyone have any ideas why? Function Upload_SAP_AGR_USERS4() Dim F As Long, sLine As...

Hi, I am tryig to import many text files into MS Access. They are all tab delimited and have NO column headers, but they all have varying number of columns and data types. Rather than using the Import wizard for every single text file, is there a way to write some code in VBA to upload the...

Hi, Yes i have set the field names to 'False', but it is still not accepting the file. I have also tried using a schema file, but i seem to be getting the same error message. I wouldnt have thought importing a tab delimited text file with no field names would have been such an issue?? Any...

Thanks for this, but unfortuantely when i do this an error message is shown as "F1 doesnt exist". any idea how to overcome this?

Hi, Does anyone know how to import a text file into a table that does not have field names and without a specificiation? The reason I ask is because I need to import many text files and I do not want to create a new specification for each file name. Any help would be appreciated. Thanks!

Hi, I am writing some VBA script to import a text file into Access. However, the text file is very large, so I would only like to import the records between a specified date. Is there any way that i can specify a date range and only import the relevant records from a text file? Thanks for...

Thank you so much - this has really helped me. Its working really well for all the cells which contain a date, but when it finds a cell which is blank, the code fails and shows warning of 'Type Mismatch'. How can I work around this? Thanks again

I am controlling an MS Excel spreadsheet from MS Access using VBA. I want to change a column from text format to Date format. To change the format is simple, but it does not activate the fields until they are double clicked on. When I try to programme this it does not work. I have tried...