VBA in Access

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?
 
Joined
Mar 20, 2012
Messages
764
Reaction score
4
Do you just need to have CSV Files imported into access and separate fields based on a carrot (^)?
 
Joined
Jul 9, 2012
Messages
24
Reaction score
0
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top