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

Excel 2 Access

P: n/a
Hi all,

Can you write how can I import only some columns of excel sheet ot an
access table?
For example: in excel sheet i have (firstname, lastname, obtmarks,
result, grade)
but in access table i only have (firstname, lastname, result)
and i don't want access to create fields for (obmarks and grade) i
just want to have 3 fields in access.
I appreciate your help in this regard,

farhad

Jun 6 '07 #1
Share this Question
Share on Google+
3 Replies

P: n/a
"Farhaad Faaique" <fa******@gmail.comwrote in message
news:11********************@w5g2000hsg.googlegroup s.com...
Hi all,

Can you write how can I import only some columns of excel sheet ot an
access table?
For example: in excel sheet i have (firstname, lastname, obtmarks,
result, grade)
but in access table i only have (firstname, lastname, result)
and i don't want access to create fields for (obmarks and grade) i
just want to have 3 fields in access.
I appreciate your help in this regard,

farhad
Use a linked table to link to your Excel sheet then use an append query on
the three required fields to append the data to your table.

HTH - Keith.
www.keithwilby.com

Jun 6 '07 #2

P: n/a
On 6 Giu, 07:35, Farhaad Faaique <farha...@gmail.comwrote:
Hi all,

Can you write how can I import only some columns of excel sheet ot an
access table?
For example: in excel sheet i have (firstname, lastname, obtmarks,
result, grade)
but in access table i only have (firstname, lastname, result)
and i don't want access to create fields for (obmarks and grade) i
just want to have 3 fields in access.
I appreciate your help in this regard,

farhad
Hi farhad

I have written an application which does also that (through a drag
drop visual ide).

1. create a connection to your sheet
2. New Data Surce Right click for context menu - Show a Union query
try query quick export
here:

DataTime Documentation
http://cam70.sta.uniroma1.it/DataTimeDocumentation/
DataTime Universal (downloadable)
http://cam70.sta.uniroma1.it/DataTimeUniversal/

There are clearly tons of other methods.But clearly I like to
advertise my application ;-).

In case need more help jut let me know.

Tommaso

Jun 6 '07 #3

P: n/a
"to**************@uniroma1.it" <To**************@gmail.comwrote in message
>
There are clearly tons of other methods.
Yes, all built-into Office applications, there is no need whatsoever for any
add-in to achieve the OP's aim.
But clearly I like to
advertise my application ;-).
But not here please, it's a direct violation of the group charter. This
group is for free advice and help. NO advertising please.

Thank you.

Keith.

Jun 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.