Hi,
could you help me please.

I have csv file:

#text1.1=#text2.1 !text3.1
#text1.2=#text2.2 !text3.2
...

I need fill this csv to access table with vba:
table:
----------------------------------------------------
| ID(automatic) | all row | text1.x | text2.x | text3.x |
----------------------------------------------------
Could you help me with vba, please (beginner)

I am not sure what you have here. Please post some sample lines from the file if the data is not sensitive.

It looks like on each line you have three columns, each column ending with .1, .2, .3, and each column delimited by #, =, or !.

What you need to do is read this file one line at a time, then split the line into an array using a delimiting character, or ".", and then open your local table and do something like:

rs.AddNew
rs("All Row") = ?
rs("text1.x") = st1stVariable
rs("text2.x") = st2ndVariable
rs("text3.x") = st3rdVariable
rs.Update

Looking forward to more info.

HTH

mmcdonal

csv for examle:
#a_string1=#a_string2 !a_string3 ...first row of csv(record of table)
#a_string1=#a_string2 !a_string3 ...second rowof csv(record of table)
...

I have in access this table:
my_table(
id automatic_number,
all_row text,
string1 text,
string2 text,
string3 text,
)

my_table.all = all row in csv
my_table.string1 = string between first "#" and first "="
my_table.string2 = string between second "#" and first " !"
my_table.string3 = string between first " !" and end of row(\n)

I'd like fill data from csv into my_table.