Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing into Access

    I asked a question about importing a QuattroPro database into Access a week or so ago. The impression that I got from the pundits is that there is nothing "out of the package" to do this. Fine. So what I can do is to save the QuattroPro database in another format, then import it into Access.

    I have done it with two methods: saving it as an Excel workbook and a dbase database. I prefer the Excel method because it allows me to look at multiple databases if I had several on several worksheets and the field names are not restricted to 8 letters. If my first row contains a title, I can also name the range of cells in Excel and import the range.

    However, I am open to the wisdom of others if they feel there is a better way.

    But there is one final question. If the user does not have Excel installed on the computer, there is no way to save the range of cells under a name. Ok, so I can delete the rows above the database in QuattroPro before I save it. However, if I don't have Excel installed on the computer, will I still be able to import the Excel workbook with the database into Access? In other words, does Access have an Excel workbook "convertor" (for want of a better word) as a default install that will allow you to import Excel worksheets?

    By the way, I am usually humbled by most of you, so if the answer involves macros - ouch <img src=/S/ouch.gif border=0 width=15 height=15>
    ! I really need things in simple terms. Thanks. <img src=/S/kiss.gif border=0 width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing into Access

    Access can import an Excel spreadsheet if the converter was installed on the machine with Access. It doesn't require or use Excel itself for the process. There is an import wizard in Access that should allow you to choose an Excel worksheet type file to import, but if the wizards aren't installed, you won't be able to do this without macros or code.

    By the way, in Access-speak, macros mean something entirely different from what the word means in the rest of office, so be sure you're actually talking about macros and not code in this forum, or you'll get the wrong kind of answer.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Importing into Access

    But I am right in believing that the converter is "out of the box", meaning it comes with Access. No need to reply if this is true. I believe if you do a standard install, it is there.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Importing into Access

    Don't ever make that assumption. I can't recall which converters are installed by default or if any are. You would have to check the documentation to see what gets included with a "typical" installation.
    Charlotte

Posting Permissions

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