Importing columns from an Excel Table into Access

[Ayo]

I don't know if this is possible or not, but I would love any ideas and help
on how to accomplish it. I have an excel table and I need to import some of
the columns into access, as a table. This table will have to be updated
regularly on a weekly bases with new data from the excel table.
I need to know first, if this is possible and secondly how to write the
code to accomplish it. I have never written code to import excel files into
access before and I am not even sure how to start. Any help in the right
direction will be greatly appreciated. Thanks.
Ayo.

 

[Jeff Boyce]

Ayo

From your description, it sounds like you are trying to "move" a copy of
data from Excel to Access, and then possible renew what you have in Access
from another set of data from Excel each week.

Another option would be to start in Access, link to the Excel spreadsheet
and NEVER have to move a copy of data.

(but I can't be sure from your description whether the data is "new" or
"update" or ...?)

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[Diyisfun]

I import Excel data ino Access all the time, I dont use any code.
Just do a file import & select the columns required from Excel.
If you are unly using it as a reference in Access (That is all I do), then
every week re import the new Excel file using the same name & all your
queries/reports will still run.
I hope that is what you are trying to do.

 

[Ayo]

There are new data every week so that the data in access will be updated with
the data from excel. And since the people we are doing this for are not so
sarvy with access, we want to create a button for them in access that would
do the importing from excel and append the data into the old data in access.
This way they can just keep usingthe access database that we setup for them
and the only thing they will need to do, weekly, is to update their database.
We don't want to be manageing their data for them. We just want them to be
able to get the data into access and manage it they way they want, as they
are doing right now.
So how mission now is to figure out a way for them to be able to get the
data from excel into access, on a weekly basic, without and problems or
headaches.

 

[Diyisfun]

I think as previous poster (Jeff) has said, link it to the Excel data, no
updating required.

 

[noreply@noreply]

Adornment has an installed supposal of 2 or 3 1000000 players, all of whom
cov infamy[/url:shmgu76o]can create 3-D files - their characters, or avatars," Harmon says.A small Washington organisation that owns six of Z Corp.'s printers has already started to check the industry among gamers, and recovered the status to be irresi (http://www.ugamegold.com/city-of-villains-infamy/:shmgu76o).

 

[noreply@noreply]

I fully support you, this is my task. I hope you better: Shanghai massage[/url:5j084h5g]| Shanghai escort[/url:5j084h5g]| massage Shanghai[/url:5j084h5g]| massage in Shanghai (http&# (http&# (http&# (http://www.okmassage.net:5j084h5g)w...t:5j084h5g)ww.okmassage.net:5j084h5g)5j084h5g]

 

[noreply@noreply]

[color=#0000ff:3rmaho4f]Rich impression[/color:3rmaho4f][/u (http://www.b2bsneaker.com/se/64.html:3rmaho4f)aho4f
[color=#0000ff:3rmaho4f]Bold proposals[/color:3rmaho4f][/u (http://www.b2bsneaker.com/se/65.html:3rmaho4f)aho4f
[color=#0000ff:3rmaho4f]Innocent singer[/color:3rmaho4f][/u (http://www.b2bsneaker.com/se/66.html:3rmaho4f)aho4f
[color=#0000ff:3rmaho4f]Boasting the rooster[/color:3rmaho4f][/u (http://www.b2bsneaker.com/se/67.html:3rmaho4f)aho4f
[color=#0000ff:3rmaho4f]Other people's scourge[/color:3rmaho4f][/u (http://www.b2bsneaker.com/se/68.html:3rmaho4f)aho4f]

 

[tulihong]

I fully support you, this is my task. I hope you better: Shanghai

massage[/url:5j084h5g]| Shanghai escort[/url:5j084h5g]| massage
Shanghai[/url:5j084h5g]| massage in Shanghai (http&# (http&# (http&#
(http://www.okmassage.net:5j084h5g)ww.okmassage.net:5j08
4h5g)ww.okmassage.net:5j084h5g)ww.okmassage.net:5j084h5g)5j0
84h5g]