VBA in Access

N

newuser123

Joined
Jul 9, 2012
Messages
24
Reaction score
0
I have a table consisting of only one field in access.

The data is imported from many csv files.

The delimiter is ^.

I want to write some VBA so that it splits the data by the delimiter.

So far:

Code: 
Sub Test
 
Dim rst As DAO.Recordset
Set rst = CurrentDb.OpenRecordset("MyTable")
 
Do Until rst.EOF
 
    ' something must go here to do the splitting but I can't get it to work
    
    rst.MoveNext
 
Loop
 
rst.Close

End Sub

Any ideas please?
 
Do you just need to have CSV Files imported into access and separate fields based on a carrot (^)?
 
Actually it's a lengthy process involving importing the csv files based on certain criteria, removing a few rows and columns then applying a filter, etc.

I've done all this using VBA in Excel except there are many files and I ran out of memory, so thought access might help.
 
Back
Top