I am writing a sql statement in VBA access using recordets, where the table only has one text column.
the select statement used is as follows;
par = "Select * from core1 order by idnumb"
Set rst = db.OpenRecordset(par)
ads1 = Len(rst.Fields(1).Value)
the text in the table in one column in...
I am looking to read some information from a fixed width text file. Using VBA in Access i want to put an if statement depending on the first two characters. Then I want to change one of the characters.
can anyone point me in teh right direction and perhaps supply me with some sample code.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.