Asked by:

devweez
Rating : No Rating
Questions Asked: 23
Tutorials Posted: 0

 

$10.00 Need assistance to insert comma delimeted text file into Access Database

• From Computer-Science: Object-Oriented-Programming , Computer-Science: Programming-Methods
• Closed, but you can still post tutorials
• Due on Jul. 24, 2009
• Asked on Jul 21, 2009 at 10:15:55PM

Q:

I have a text file that I need to insert on my access database. The problem is that as yo can see from below. The rows that are on the file do not always have the same amount of colums. How can i get this text to insert into the database and working. The file get updated automatically and I would need to get the rows inserted automatically.

Here is the GPS data strings coming in



$GPRMC,221442,A,2601.3038,N,08021.5652,W,0.0,298.4,100709,5.6,W,D*14

$GPRMB,A,0.00,L,,,D*0C

$GPVTG,298.4,T,304.0,M,0.0,N,0.0,K*4E

$GPXTE,A,A,0.00,L,N,D*06

$GPRTE,1,1,c,*37

$SDDBT,,f,,M,,F*28

$SDDPT,,*57

$SDMTW,,C*1A

$SDVHW,,,,,,N,,K*5B

 

Attachments:
GPS_MDB.zip (10K)
Test.txt (0K)

Attachments: