.dbf to vb service or .net service to sql database

how to transfer data from .dbf to vb service to sql database
so I can generate a report for example
I have a clkdata.dbf which contains badgeno int ,datatime date,time varchar,clkid int.
what code would it need to transfer it to sql from dbf using vb thanks :)
kennethzxcAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kennethzxcAuthor Commented:
here is the old sourcecode
I'll just change the values of the code but
I don't know what OS,SQL version and Visual Studio version and VPOLEDDB.1 will I use that is compatible with each other so I can't start thanks

FingerTech Visual Foxpro 9 DB                                                
 - clkdata.dbf --> holds mainly the attendance data needed to suffice the granularity requirement                                                
 - badge.dbf --> holds the information of the employee                                                
 - Timelog Table --> holds all information for the attendance report system                                                


Id      bigint
LogDate       datetime
LogType      nvarchar(3)
DoorNo      smallint
PeopleId      nvarchar(10)
      




id = sysgen                        
Logdate = clkdata.datetime                        
if clkdata.clkid = 1 then logtype = "IN" else logtype = "OUT"                        
DoorNo = "1"                        
PeopleId = badge.empno                        
                        
The source code and the dbf files is attach in .rar thanks :D
How to create service that checks the dbf files by 20000 secs ? maybe put a timer?
sourcodeold.txt
erro.txt
0
kennethzxcAuthor Commented:
command is missing required clause. on DB Command.Fill(DSPAGEDATA,"Badge")
when I try to run it on a windows app , OleDbException was unhandled thnks guys
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.