469,086 Members | 1,271 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,086 developers. It's quick & easy.

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
Jul 19 '05 #1
5 3619
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" <po********@yahoo.com> wrote in message
news:bb**************************@posting.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

Jul 19 '05 #2
"powerrun" <po********@yahoo.com> wrote in message
news:bb**************************@posting.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 ...
http://www.microsoft.com/office/community/

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserv...y/centers/iis/

Jul 19 '05 #3
Thank you for the advise, Tom!

Mel

"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message news:<bn*********@kcweb01.netnews.att.com>...
"powerrun" <po********@yahoo.com> wrote in message
news:bb**************************@posting.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 ...
http://www.microsoft.com/office/community/

Jul 19 '05 #4
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:<OY*************@TK2MSFTNGP10.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" <po********@yahoo.com> wrote in message
news:bb**************************@posting.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

Jul 19 '05 #5
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" <po********@yahoo.com> wrote in message
news:bb**************************@posting.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:<OY*************@TK2MSFTNGP10.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" <po********@yahoo.com> wrote in message
news:bb**************************@posting.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

Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Raymond | last post: by
1 post views Thread by G | last post: by
2 posts views Thread by Anne Sachleben via AccessMonster.com | last post: by
5 posts views Thread by Simon | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.