Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    183

    Unanswered: determining DB type

    I've received an email with a foreign DB type from a russian company. Well, access can't import anything from it, and the GUI that comes with it is my only way to viewing the data.

    Well, I've chucked them a mail hoping to get the proper ODBC driver to access the lot with a query tool as the VB GUI for the database is limited to basic filtering.

    Are there any tools out there for figuring out formats?

    I've tried everything form old Access to Sybase, over foxpro to God knows what format. I am only guessing its a standard DB format, as its a VB gui... but for all the facts I know, it might just be encrypted.
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

  2. #2
    Join Date
    Oct 2005
    Posts
    178

    Wink

    Try this routine VB
    On your form Set Text1 object multiline to true
    if the resulting display is garble then it's probably encripted, if readable you can export it to MS ACcess.

    Code:
    Dim NewLine As String
    Dim v As Integer
    Dim y As Integer
    Dim LineText() As String
    
    MousePointer = vbHourglass
    
    Text1.Text = ""
    
    Open UnknownDataPathAndName For Input As #1
    'Read data
    
    Linecount = 0
    v = 0
    'Assign each line to array
    Do Until EOF(1)
    Line Input #1, NewLine
    Linecount = Linecount + 1
    
    ReDim Preserve LineText(Linecount)
    
    LineText(Linecount) = Text1.Text + NewLine
    
    Loop
    Close #1
     Text1.Text = ""
     
     ' Display the resulting text
     For y = 1 To Linecount
     Text1.Text = Text1.Text + LineText(y) + vbCrLf
     Next
    
    MousePointer = vbdefault
    Last edited by fredservillon; 12-09-05 at 18:20.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •