Importing only specific fields into a table

  • Thread starter Thread starter Fatz
  • Start date Start date
F

Fatz

I have a spreadsheet with 60 columns that I have setup currently to
import to a specific table through a button...and then append only the
5 columns I want to look at into my main table. Is there a way to
code the import to tell the spreadsheet to only grab the 5 columns I
want to use from the spreadsheet??? I know I have seen it before on
Google but I can't find it anywhere!!

I am a novice...so any sample code would be great.

I appreciate any help!!

Thanks,
Chris
 
I have a spreadsheet with 60 columns that I have setup currently to
import to a specific table through a button...and then append only the
5 columns I want to look at into my main table. Is there a way to
code the import to tell the spreadsheet to only grab the 5 columns I
want to use from the spreadsheet??? I know I have seen it before on
Google but I can't find it anywhere!!
Click to expand...

No code is needed. I'd suggest using File... Get External Data... Link
to *link* to the spreadsheet rather than importing the whole thing;
and have an Append query based on this linked table, appending just
the desired five fields.
 
John-

So simple! Thanks so much.

-Chris


John Vinson said:
No code is needed. I'd suggest using File... Get External Data... Link
to *link* to the spreadsheet rather than importing the whole thing;
and have an Append query based on this linked table, appending just
the desired five fields.
Click to expand...
 
Back
Top