Query won't let me get more than 95 fields
 

I need to import 100+ fields but the query I created of an Access database
won't seem to let me get more than 95 fields. I can break it up but would
like to keep it simple by getting all the fields in 1 query.

Is there a way to bring in 100+ fields in an excel query of an access
database?

Query won't let me get more than 95 fields
 

Choose DataImport External DataImport Data
Locate and select your database, then click Open
Select a table or query, then click OK
Select a starting cell for the data, click OK

Brian wrote:
I need to import 100+ fields but the query I created of an Access database
won't seem to let me get more than 95 fields. I can break it up but would
like to keep it simple by getting all the fields in 1 query.

Is there a way to bring in 100+ fields in an excel query of an access
database?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Query won't let me get more than 95 fields
 

Debra,

Thank you. Can this method be automated. I was using a Query with automatic
refresh so when I open the file, it goes and gets the data. I thought with
the method you suggested, the process would be manual. Any thoughts?

Brian

"Debra Dalgleish" wrote:

Choose DataImport External DataImport Data
Locate and select your database, then click Open
Select a table or query, then click OK
Select a starting cell for the data, click OK

Brian wrote:
I need to import 100+ fields but the query I created of an Access database
won't seem to let me get more than 95 fields. I can break it up but would
like to keep it simple by getting all the fields in 1 query.

Is there a way to bring in 100+ fields in an excel query of an access
database?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Query won't let me get more than 95 fields
 

You should be able to set this one to refresh on open too. Right-click
on it, and choose Data Range Properties.
Add a check mark to Refresh data on file open, then click OK

Brian wrote:
Debra,

Thank you. Can this method be automated. I was using a Query with automatic
refresh so when I open the file, it goes and gets the data. I thought with
the method you suggested, the process would be manual. Any thoughts?

Brian

"Debra Dalgleish" wrote:


Choose DataImport External DataImport Data
Locate and select your database, then click Open
Select a table or query, then click OK
Select a starting cell for the data, click OK

Brian wrote:

I need to import 100+ fields but the query I created of an Access database
won't seem to let me get more than 95 fields. I can break it up but would
like to keep it simple by getting all the fields in 1 query.

Is there a way to bring in 100+ fields in an excel query of an access
database?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html