Professional Web Applications Themes

Merging Excel Info into existing Access Database Query - ASP

Help! I have tons of info loaded into an excel spreadsheet that I need to transfer into an existing database in access. There is a specific Query I need the information to transfer to. This Query has existing records in it that I don't want to over-write. Is this possible?? Melissa...

  1. #1

    Default Merging Excel Info into existing Access Database Query

    Help! I have tons of info loaded into an excel spreadsheet that I
    need to transfer into an existing database in access. There is a
    specific Query I need the information to transfer to. This Query has
    existing records in it that I don't want to over-write.

    Is this possible??

    Melissa
    powerrun Guest

  2. #2

    Default Re: Merging Excel Info into existing Access Database Query

    Do you need to do this over and over via ASP, or are you just talking about
    doing it once? If just once, just do an import in Access.

    Ray at work

    "powerrun" <pooyou_mel> wrote in message
    news:bb9482f7.0310201111.2ab7e93bposting.google.c om...
    > Help! I have tons of info loaded into an excel spreadsheet that I
    > need to transfer into an existing database in access. There is a
    > specific Query I need the information to transfer to. This Query has
    > existing records in it that I don't want to over-write.
    >
    > Is this possible??
    >
    > Melissa

    Ray at Guest

  3. #3

    Default Re: Merging Excel Info into existing Access Database Query

    "powerrun" <pooyou_mel> wrote in message
    news:bb9482f7.0310201111.2ab7e93bposting.google.c om...
    > Help! I have tons of info loaded into an excel spreadsheet that I
    > need to transfer into an existing database in access. There is a
    > specific Query I need the information to transfer to. This Query has
    > existing records in it that I don't want to over-write.
    >
    > Is this possible??
    Probably, but you'd also most likely get a better answer if asked in an MS
    Access newsgroup ...
    [url]http://www.microsoft.com/office/community/[/url]

    --
    Tom Kaminski IIS MVP
    [url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS
    [url]http://mvp.support.microsoft.com/[/url]
    [url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]



    Tom Kaminski [MVP] Guest

  4. #4

    Default Re: Merging Excel Info into existing Access Database Query

    Thank you for the advise, Tom!

    Mel

    "Tom Kaminski [MVP]" <tomk (AT) mvps (D.O.T) org> wrote in message news:<bn1c10$m1a8kcweb01.netnews.att.com>...
    > "powerrun" <pooyou_mel> wrote in message
    > news:bb9482f7.0310201111.2ab7e93bposting.google.c om...
    > > Help! I have tons of info loaded into an excel spreadsheet that I
    > > need to transfer into an existing database in access. There is a
    > > specific Query I need the information to transfer to. This Query has
    > > existing records in it that I don't want to over-write.
    > >
    > > Is this possible??
    >
    > Probably, but you'd also most likely get a better answer if asked in an MS
    > Access newsgroup ...
    > [url]http://www.microsoft.com/office/community/[/url]
    powerrun Guest

  5. #5

    Default Re: Merging Excel Info into existing Access Database Query

    I only need to do it once, but when I tried to do an import, it wanted
    to import it as a table. The information I have needs to be imported
    into a specific Query with existing info.

    It's obvious I've not done an import into a query before, and I truly
    appreciate your help.

    If there's any more info you can think of, please don't hesitate to
    post me again.

    Thanks!
    Melissa

    "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message news:<OYs2Q5zlDHA.708TK2MSFTNGP10.phx.gbl>...
    > Do you need to do this over and over via ASP, or are you just talking about
    > doing it once? If just once, just do an import in Access.
    >
    > Ray at work
    >
    > "powerrun" <pooyou_mel> wrote in message
    > news:bb9482f7.0310201111.2ab7e93bposting.google.c om...
    > > Help! I have tons of info loaded into an excel spreadsheet that I
    > > need to transfer into an existing database in access. There is a
    > > specific Query I need the information to transfer to. This Query has
    > > existing records in it that I don't want to over-write.
    > >
    > > Is this possible??
    > >
    > > Melissa
    powerrun Guest

  6. #6

    Default Re: Merging Excel Info into existing Access Database Query

    If you only have to do it once, I wouldn't bother going through all the
    nonsense of building an ASP page...

    Ray at work

    "powerrun" <pooyou_mel> wrote in message
    news:bb9482f7.0310231253.7808e7e2posting.google.c om...
    > I only need to do it once, but when I tried to do an import, it wanted
    > to import it as a table. The information I have needs to be imported
    > into a specific Query with existing info.
    >
    > It's obvious I've not done an import into a query before, and I truly
    > appreciate your help.
    >
    > If there's any more info you can think of, please don't hesitate to
    > post me again.
    >
    > Thanks!
    > Melissa
    >
    > "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
    news:<OYs2Q5zlDHA.708TK2MSFTNGP10.phx.gbl>...
    > > Do you need to do this over and over via ASP, or are you just talking
    about
    > > doing it once? If just once, just do an import in Access.
    > >
    > > Ray at work
    > >
    > > "powerrun" <pooyou_mel> wrote in message
    > > news:bb9482f7.0310201111.2ab7e93bposting.google.c om...
    > > > Help! I have tons of info loaded into an excel spreadsheet that I
    > > > need to transfer into an existing database in access. There is a
    > > > specific Query I need the information to transfer to. This Query has
    > > > existing records in it that I don't want to over-write.
    > > >
    > > > Is this possible??
    > > >
    > > > Melissa

    Ray at Guest

Similar Threads

  1. Query to match date -- ODBD -- Access database
    By dwf in forum Coldfusion Database Access
    Replies: 1
    Last Post: December 5th, 03:39 AM
  2. Creating A New Table In Existing Access Database
    By PlayfulDragon&Phoenix in forum Coldfusion Database Access
    Replies: 5
    Last Post: November 23rd, 02:55 AM
  3. Question - query Access database
    By rappelec in forum Coldfusion Database Access
    Replies: 0
    Last Post: August 5th, 06:40 PM
  4. Error Executing Access Database Query
    By kschock in forum Coldfusion Database Access
    Replies: 2
    Last Post: April 18th, 09:54 PM
  5. HOW TO - Import all Access tables into an existing SQL Database
    By Robert in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 11th, 03:42 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139