  |
| View previous topic :: View next topic |
| Author |
Message |
Perseus
Newbie
Joined: 30 Jul 2005
Posts: 11
|
 Posted: Sep 14th, 2005 11:53 AM Post subject: csv file into access table with vba |
 |
|
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) |
|
| Back to top |
|
Perseus
Newbie
Joined: 30 Jul 2005
Posts: 11
|
| Posted: Sep 14th, 2005 02:59 PM Post subject: |
|
|
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. |
|
| Back to top |
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
