Click here to Skip to main content
15,847,903 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
i have a txt file that is exported from an attendance software as follow
Date        Time     S1    S2        Empid              In\out 
07-24-13   12:23:52  001   07      0000020009         0300000000          
07-24-13   12:24:02  001   07      0000020010         0300000000

6 columns separated by spaces.I want to import this txt file into ms access database using oledb connection.My database contain a table named import ( ID, DATE , TIME , S1 , S2 , EMPID, IN\OUT )

please note that between columns different number of spaces. Thx for any help.
Updated 23-Sep-13 22:56pm

1 solution

import text file to access database[^]

Should i assume none of them worked for you?
Share this answer
shkoukou 24-Sep-13 4:49am    
no nth worked because i have to count spaces between columns in the text file and can't find the write method to read from this txt file and insert into my access databbase

any help please

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900