how to get cap file into database

Hot Topic

A question about sqlxml
Report Model missing some fields
last 30 dates measures
delete trigger
saving package with Protectionlevel set to serverstorage fails
Reporting Services: timeout issue
Join 3 Tables Return all records even null...
SQL Query Help....
SQL 2005 with Sharepoint 2007
HELP!!! Can not restore database from only back up I have

SQL Server

error adding a column to a table
Copy values from previous row
Report Server internal error
R
How to spool into a script file in SQL Server?
Shortcut to insert new GUID into uniqueidentifier cell in MSSQL Management Studio Express?
Excel Numbers format
upgrade from 2000 MSDE to 2005 Express - Enable TCP/IP by default & Current Version of SQL running?
Alignments between tasks and constrains
peer to peer - pending change stuck in queue

how to get cap file into database

how to get the cap file into database


Answer this question

how to get cap file into database

  • Go4More

    CAP is the file extension for a ompressed music file. It can also be the file extension for the Ventura Publisher caption and for the Telix Session Capture file.

  • leonlai

    You can convert into binary and insert.

  • foobarX

    What is a cap file


  • AdelioStevanato

    AA0B0105200706040003021500FF1A7D77
    AA0B0105200706040003022600FF1A7E76
    AA0B0105200706040003022800FF1A7F7B
    AA0B0105200706050000070900FF1A8006
    AA0B0105200706060003001500FF1A810D
    AA0B0105200706090000009300FF1A820C
    AA0B0105200706570003001100FF1A830F
    AA0B0105200707340003068000FF1A8402
    AA0B0105200707400003065500FF1A8508
    AA0B0105200707460003068400FF1A8601
    AA0B0105200707480003021700FF1A8700
    AA0B0105200707500003023200FF1A8801
    AA0B0105200707540003022100FF1A8906
    AA0B0105200707560003023500FF1A8A79
    AA0B0105200707580003023700FF1A8B76
    AA0B0105200707590003065700FF1A8C74
    AA0B0105200708000003021900FF1A8D7E
    AA0B0105200708010003067100FF1A8E74
    AA0B0105200708030003067800FF1A8F7C
    AA0B0105200708030003022300FF1A9001
    AA0B0105200708040003002800FF1A910E
    AA0B0105200708060000069200FF1A920B

    this is the text i am getting in cap file.

    this is 34 character record. it contains caphead(2), machineno(2), swipe_date(8),swipe_time(4),psno(8),IOMode(2),MCRC(2),RSNO(4),Checksum(2).

    this file is the current date of the attendence.



  • Gouranga1

    Please post an example of your input file.

    ".cap" files mean nothing in this circimstance, that is a unique extension from your application. Is it delimitted or fixed or what


  • reichard

    have a card machine, when i swipe the card i am getting the details of the employee by .cap file. then i have to take those details into the sql server database tables. how it is possible.


  • SteveC_65

    i have a card machine, when i swipe the card i am getting the details of the employee by .cap file. then i have to take those details into the sql server database tables. how it is possible.

  • anu_ooo

    Use a flat file source with a fixed-width record layout.

  • how to get cap file into database
Answer this question