Excel 2 Access

[Farhaad Faaique]

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

[Keith Wilby]

"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

[tommaso.gastaldi]

On 6 Giu, 07:35, Farhaad Faaique <[e-mail]:

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

[Keith Wilby]

"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.