Import Columns from SQL Database

[bwilde@gmail.com]

I am new to Access and have a quick question. I'm trying to import
data from a SQL database, but the table that I'd like to import is
enormous. I have gotten all of the connections to work, but as far as
I can tell, there's not a way to import certain rows of the SQL table
into a new table in Access. Is it possible to somehow use a SELECT
statement rather than importing the entire table?

Thanks,
Ben

[lyle]

Re: Import Columns from SQL Database

On Mar 26, 9:48 pm, bwi...@gmail.co m wrote:

I am new to Access and have a quick question. I'm trying to import
data from a SQL database, but the table that I'd like to import is
enormous. I have gotten all of the connections to work, but as far as
I can tell, there's not a way to import certain rows of the SQL table
into a new table in Access. Is it possible to somehow use a SELECT
statement rather than importing the entire table?
>
Thanks,
Ben

Another way.

1. Create an ADP.
2. Connect to the SQL DB from the ADP (File -Connections - or use
the dialog that will open when the ADP is created.)
3. Close the ADP.
4. Open or create the MDB where you want the new table to live.
5. Click File -Get External Data -... follow the prompts, select
the ADP, select the table. Click OK. That's it. Access now looks after
everything.