Import question.

[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?

 

[RJamis]

Yes, you can create different tables and only import certain columns into
each table.

 

[Christi Lee]

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.

 

[Steve]

Hi Christi,

r1-500 is not the correct syntax! Should be R1:R500 to get all the data in
column R from row 1 to row 500. If you want all the data in columns R, S , T
from row 1 to row 500, the syntax is R1:T500.

Steve
(e-mail address removed)

 

[Patricia]

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.