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

Posted on 2013-10-07
Medium Priority
Last Modified: 2013-10-07
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 :)
Question by:kennethzxc
  • 2

Author Comment

ID: 39554441
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?

Accepted Solution

kennethzxc earned 0 total points
ID: 39554442
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

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question