Importing Excel into Access

[Guest]

I tried to import Excel into Access but it keeps adding the unused columns
and rows. Is there a way to get just the data from Excel into Access??

 

[Dave Miller]

Either use an Access Macro to define the range you would like to
import or do it via VBA:

DoCmd.TransferSpreadsheet acImport, , "tblImport", "C:\FileName.xls",
False, "A1:F16"

Dave

 

[Guest]

Macro worked great on two of the spreadsheets but I have one large
spreadsheet that I don't want to import the entire data. I only want some of
the colums of data. How do I specify more than one range.

 

[Guest]

Either use an Access Macro to define the range you would like to
import or do it via VBA:

DoCmd.TransferSpreadsheet acImport, , "tblImport", "C:\FileName.xls",
False, "A1:F16"

Dave

 

[Guest]

If I hide the columns I don't want will it ignore them and only import the
data shown?

 

[Guest]

One alternative is to create named ranges in the Excel spreadsheet, and then,
in Access, import the named range, as opposed to the entire spreadsheet. For
more info on named ranges in Excel see:
http://www.cpearson.com/excel/named.htm

Dave

 

[Guest]

The easiest way is through the Import Wizard.

Click File, Get External Data, Import Wizard and change your File Type to
Excel.

On the 4th screen of the wizard, you can select the columns you do not want
to import and place a check in Skip.

This will not import any column that you have skipped over.

 

[aaron.kempf]

Access isnt' a real database.

SQL Server has real ETL captabilities, Access MDB is for babies and
retards that don't have the mental capacity to learn a real database