By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,249 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

Extracting data from Excel into Access Table

P: n/a
Here is an issue i've been trying to figure out which i do not have an
answer to. Basically i have an excel spreadsheet which has data that
i copy and paste from another resource. I also created an excel object
in a module in access which directly links to the excel spreadsheet.

The data in excel varies from day to day. i.e.(Spreadsheet will have
data from 6/1/05 - 6/4/05 for one day, and it will increase by one day
going forward.) How do you program in the module to tell it to take
all the data that's in excel and transfer it into the table?

Please advise. thank you.

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Consult Access's help on the TransferSpreadsheet method of the Docmd
object. Your Excel object may not be necessary if you just want to
pull all the data as is into a table.

Nov 13 '05 #2

P: n/a
On 10 Jun 2005 06:13:17 -0700, "ph*******@gmail.com"
<ph*******@gmail.com> wrote:

An elegant solution is to create a linked table to your Excel file in
Access, and then use an Append query to copy the data from it to one
of the other tables.

-Tom.

Here is an issue i've been trying to figure out which i do not have an
answer to. Basically i have an excel spreadsheet which has data that
i copy and paste from another resource. I also created an excel object
in a module in access which directly links to the excel spreadsheet.

The data in excel varies from day to day. i.e.(Spreadsheet will have
data from 6/1/05 - 6/4/05 for one day, and it will increase by one day
going forward.) How do you program in the module to tell it to take
all the data that's in excel and transfer it into the table?

Please advise. thank you.


Nov 13 '05 #3

P: n/a
Thanks for your reply. Let me try to break down my problem more in
detail. i basically do a copy and paste from another application to
get the data into excel, and after i'm done with all the data copied
into excel, i record a macro that converts text to column and from that
i'm trying to write a module in access that will take all the
information from excel and dump it in a table. the problem with it is
that the data changes everyday, so i need to always go back to excel
and either insert a new column or row or i usually just redo my process
of copying and pasting with the new data. Please advise.

I will try the sample that you've given me and see what it does.
Hopefully that is the only code that i can use. Thank you .

Nov 13 '05 #4

P: n/a
Per ph*******@gmail.com:
I will try the sample that you've given me and see what it does.
Hopefully that is the only code that i can use. Thank you .


No chance whatsoever of that code even *beginning* to work for you. It was
supplied only as a departure point in figuring out how to write your own.
--
PeteCresswell
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.