importing particular fields

[dodge]

I am trying to import an excel spreadsheets and I just want to bring in certain 'fields' in that spreadsheet.(Its a timesheet that I just need certain data from) How do I return the particular fields that I want out of that spreadsheet?

 

[John Nurick]

Hi Dodge,

Basically, you can't select Excel columns to import or link. Usually
it's simplest to link the whole lot (or import if linking won't work)
and then use an append query to move the data you actually want to the
table where you want it.

About the only exception is when the columns you want are in one solid
block. In that case you can define a named range in Excel to include
them, and then import the range into Access. (Excel lets you name
non-contiguous ranges, but Access won't import them.)