Search results

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, 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...

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...