Importing Spreadsheet/Linking spreadsheet

J

jwr

This is my first time to attempt this. Your assistance will be greatly
appreciated!

I receive information daily via email in the form of an excel worksheet. I
need to bring that information into my access database.

I have a query from which I created a table. This query is emailed to
end-user who inputs information daily and emails back to me. I have saved
this info on my drive C; imported into access. The first attempt, I get
message that it is unable to import-Error. When I close out of that process
and look at the actual table, the information is there.

If I attempt to link information, the system overwrites the previous
information.

What I am wanting to do is add to the information in the table on a daily
basis -- not overwrite the information. How do I do this??? Can this be
done from an email without saving the information on drive C or other
location?

Guidance please.

JR
 
D

Douglas J. Steele

Linking means that whatever is currently in the spreadsheet is all you'll
see.

If you're only getting the new data through the spreadsheets, your best bet
is to import the data into Access, then link every day to the new
spreadsheet. Once you've linked to the spreadsheet, you can write an Append
query that will add the new data to your existing data.
 
J

jwr

Excuse my questions, please. Am I understanding you to say that I should
import - the first time - into Access. After that first time, link to each
spreadsheet?

When I linked to the spreadsheet, I was asked if I wanted to overwrite
existing data. How do I link without overwriting? I have not done an
Append query, but I am guessing that access explains how. At what point do I
do the append query?

Sorry if these are questions that should be self-explanatory.

Thanks for your help.
 
D

Douglas J. Steele

How are you attempting to link today? I don't believe the "do you want to
overwrite" message should be appearing.
 
J

jwr

Doug -
I cannot recreate my "overwrite message."

My scenario is this:
I run a query, then email to end user.
End user fills in the blanks and emails back to me.
I save info in excel. (But would prefer skipping this step if I can go
directly to access)
In Access, File/Get External Data/Import -- select file type of Excel and
then select the returned query that I saved.

NOW I am getting the message that there is an error and the file did not
import. Is this because I do not have the query in a file folder, but just
saved on drive "C"?

I am trying to import the returned query to a table that I created using the
same query so all fields/formats, etc should be the same.

This is probably very simple and I am just missing a step somewhere.

Assuming that this worked, what would be my next step??

Thanks you,
JR
 
D

Douglas J. Steele

Sorry, but I'm not sure what you mean by "select file type of Excel and then
select the returned query that I saved", nor what you mean by "I do not have
the query in a file folder, but just saved on drive 'C'"

Unfortunately, the sort of thing you're trying to do isn't possible in just
Access: you really have no choice but to use Excel (or just text) as an
intermediary. (although I believe Access 2007 will have that capability)
 
J

jwr

When I am importing, I select browse my documents, select excel file type
and then the query from excel. When I saved the query originally, I did not
put it in a file folder.

I have obviously missed something. Would you be kind enough to give me
direction in getting a spreadsheet from excel into access and then into a
table(s) already created in access??

Thank you,
JR
 
D

Douglas J. Steele

Still don't understand what you mean by not putting it "in a file folder".

To import from Excel, you select File | Get External Data then either Import
or Link Tables. You change the "Files of Type" to Excel, then find the .xls
file.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top