Import question.

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?
--
Christi Lee

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

"Christi Lee" wrote:

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?
--
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.
--
Christi Lee


"RJamis" wrote:

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

"Christi Lee" wrote:

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?
--
Christi Lee

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





"Christi Lee" wrote in message
...
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.
--
Christi Lee


"RJamis" wrote:

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

"Christi Lee" wrote:

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?
--
Christi Lee

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.

"Steve" wrote:

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





"Christi Lee" wrote in message
...
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.
--
Christi Lee


"RJamis" wrote:

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

"Christi Lee" wrote:

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?
--
Christi Lee