Data transfer question

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fieldling
    New Member
    • May 2007
    • 30

    #1

    Data transfer question

    Ok here's one for you:

    Does anyone know if it's possible to transfer data from an MSDos database into an Access one?

    I need to know:
    a. If it can be done.
    b. How I would go about doing it.
    c. Will I still be sane at the end of it?

    Thanking you in advance.

    J
  • abolos
    New Member
    • Apr 2007
    • 65

    #2
    Originally posted by fieldling
    Ok here's one for you:

    Does anyone know if it's possible to transfer data from an MSDos database into an Access one?

    I need to know:
    a. If it can be done.
    b. How I would go about doing it.
    c. Will I still be sane at the end of it?

    Thanking you in advance.

    J

    What MSDos database? Is it Foxpro? is it dbase? Most probably you can. Suppose it is Foxpro, then you can install the FoxPro Windows version and convert the Dos to Windows table. And then you can use MS Access to import the data.

    Hope this help
    abolos

    Comment

    • fieldling
      New Member
      • May 2007
      • 30

      #3
      Originally posted by abolos
      What MSDos database? Is it Foxpro? is it dbase? Most probably you can. Suppose it is Foxpro, then you can install the FoxPro Windows version and convert the Dos to Windows table. And then you can use MS Access to import the data.

      Hope this help
      abolos
      I'm not sure which it is. I had a look in the properties and it's an MSDOS-Batch file.

      Does that mean anything to you?

      Comment

      • missinglinq
        Recognized Expert Specialist
        • Nov 2006
        • 3533

        #4
        An MS DOS batch file is the equivalent of today's Shortcut file; it's not the database, just a means of getting to the database. Most DOS based dbs have a fixed-length record format that make them fairly easy to import into Access, but it does help to know/understand the original database involved!
        You need to find out the DOS program involved, and the underlying data file. Many DOS programs use data files with the .DAT file extension, but others have a proprietary extension. Once you know this you can plan a strategy for importing the data.

        Try to find out the things mentioned above, and post them back here!

        Linq ;0)>

        Comment

        • fieldling
          New Member
          • May 2007
          • 30

          #5
          Originally posted by missinglinq
          An MS DOS batch file is the equivalent of today's Shortcut file; it's not the database, just a means of getting to the database. Most DOS based dbs have a fixed-length record format that make them fairly easy to import into Access, but it does help to know/understand the original database involved!
          You need to find out the DOS program involved, and the underlying data file. Many DOS programs use data files with the .DAT file extension, but others have a proprietary extension. Once you know this you can plan a strategy for importing the data.

          Try to find out the things mentioned above, and post them back here!

          Linq ;0)>
          Thanks for the advice. I don't really know anything about DOS. I've had another look and like before the only information I can find is in the properties and that tells me that it is a batch file.

          Where else can I look to find the info I need?

          Comment

          • missinglinq
            Recognized Expert Specialist
            • Nov 2006
            • 3533

            #6
            Use Word Pad or some other text editor and open the batch file; .bat files are plain text. Copy the text you find and post it here.

            Comment

            • abolos
              New Member
              • Apr 2007
              • 65

              #7
              MS-DOS batch file is an executable file. It executes an exe file and ....
              I think the batch file that you are talking about is the file the executes your MS-DOS program.

              Comment

              • fieldling
                New Member
                • May 2007
                • 30

                #8
                Originally posted by missinglinq
                Use Word Pad or some other text editor and open the batch file; .bat files are plain text. Copy the text you find and post it here.
                Ok, when I open the file the following text appears:

                cd\andrew
                G:\ util \ inner4 andrew


                This is just the file location.

                As the program is loading this also appears:

                Reading .LBL file

                Is that what I'm looking for?

                Comment

                • abolos
                  New Member
                  • Apr 2007
                  • 65

                  #9
                  Originally posted by fieldling
                  Ok, when I open the file the following text appears:

                  cd\andrew
                  G:\ util \ inner4 andrew


                  This is just the file location.

                  As the program is loading this also appears:

                  Reading .LBL file

                  Is that what I'm looking for?
                  The file reads:
                  cd\andrew: pointing to the folder named andrew
                  G:\ util \ inner4 andrew: is referring to drive G and to the folder util that contians the folder inner4 andrew.

                  Simply, this is not a program. But it is just a small batch file that do work instead of writing them in the Command Prompt (now CMD).

                  Comment

                  • abolos
                    New Member
                    • Apr 2007
                    • 65

                    #10
                    Originally posted by abolos
                    The file reads:
                    cd\andrew: pointing to the folder named andrew
                    G:\ util \ inner4 andrew: is referring to drive G and to the folder util that contians the folder inner4 andrew.

                    Simply, this is not a program. But it is just a small batch file that do work instead of writing them in the Command Prompt (now CMD).

                    You must find something in the folder G:\ util \ inner4 andrew that makes sense. Do you have in this folder files with extension DBF?

                    Comment

                    • fieldling
                      New Member
                      • May 2007
                      • 30

                      #11
                      Originally posted by abolos
                      You must find something in the folder G:\ util \ inner4 andrew that makes sense. Do you have in this folder files with extension DBF?
                      Couldn't find any .dbf files. I'll post back here if I do find anything. Thanks for all your help.

                      Comment

                      • missinglinq
                        Recognized Expert Specialist
                        • Nov 2006
                        • 3533

                        #12
                        Is inner4 andrew a folder or a file? If a file, what kind of extension does it have?

                        Comment

                        Working...