Import question.

  • Thread starter Thread starter Christi Lee
  • Start date Start date
C

Christi Lee

Hello. I need to import from excel to access 2003. I understand the
process although the spreadsheet that I am to use is not seperated into
worksheets. It is one long sheet. Can I Make a table called rates and just
import certain columns at a time to be able to put them into their proper
tables?
 
Yes, you can create different tables and only import certain columns into
each table.
 
Do you mean import a range instead of a sheet? If that is the case, I
tried to enter a range like r1-500 but I dont know how they want the range
worded so that it will work.
 
You can name the range in Excel and then select it from list when you import
it.

Or when you go through the wizard you change check the don't import this
column box.
 
Back
Top