Hi All,
I'm trying to write a program for importing multiple csv files into access table.
All my csv files have the same headers and record layout.I have to import it and append into one big access table.. I have never done this before or write vb program extensively. Can somebody please point...
Hi,
I am new with access. I need help to parse out last two characters from the right.
Sample Data as follow:
Toronto ON <-- 1 field
Manitoba AB <--- 1 field
VAncouver BC <--- 1 field
I need to make it two fields
Thanks....
John
Baltman,
It's almost there but I want to reset the counter to 0 and and still counting when unique_id <> unique_id
GO top
thisid=Unique_id
do while not eof()
SCAN
IF thisid=unique_id
varpage=1
else
varpage=0
ENDIF
REPLACE counter with varpage
varpage=varpage+1
endscan
enddo
this is from...
Sorry,
I'm trying to create a counter on field called page based on stream and another unique id which is Final_mail
Name ADD POSTAL STREAM PAGE Unique_ID
Johndoe 123 Avenue L1L 2L2 2 1 20
Johndoe 123 Avenue L1L 2L2 2 2...
Hi All,
I'm trying to create a counter based on page n of m. Here are the example of the data.
Name ADD POSTAL_CODE STREAM PAGE
Johndoe 123 Avenue L1L 2L2 2 1
Johndoe 123 Avenue L1L 2L2 2 2
JaneSmith 999 Avenue M1M 2P2 3 1
JaneSmith 999 Avenue...
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.