| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query of an Access database won't let me get more than 95 fields. | Excel Discussion (Misc queries) | |||
| Fields change order from MS Query to Excel | Excel Discussion (Misc queries) | |||
| Error: Number of query values and destination fields are not the s | Excel Worksheet Functions | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Hybrid Mode
