I have 2 sheets in a workbook that import data from an access on refresh. One
works and the other one doesn't. I keep getting "disk error". I would like to
delete the query and start over. How do I do this?

hi,
are you using microsoft query????
if so then right click the query range and click data range properties.
on the property box, at the top, uncheck "save query definition"
chick ok. you will get a warning about permanently removing query. chick ok.
gone. non reversible.

Regards
FSt1

"Oldjay" wrote:

> I have 2 sheets in a workbook that import data from an access on refresh. One
> works and the other one doesn't. I keep getting "disk error". I would like to
> delete the query and start over. How do I do this?
>

Thanks that deleted the query but when I tried to setup a new query and got
to Save query I got an error message "The MS Office access database engine
couldn't find the input table "mdb.substrates"
Make sure it exists and that it spelled correctly.

It look to me that it should be looking for "substrates.mdb" but I don't
know how to change it

"FSt1" wrote:

> hi,
> are you using microsoft query????
> if so then right click the query range and click data range properties.
> on the property box, at the top, uncheck "save query definition"
> chick ok. you will get a warning about permanently removing query. chick ok.
> gone. non reversible.
>
> Regards
> FSt1
>
> "Oldjay" wrote:
>
> > I have 2 sheets in a workbook that import data from an access on refresh. One
> > works and the other one doesn't. I keep getting "disk error". I would like to
> > delete the query and start over. How do I do this?
> >

hi
not sure what method you are using but if you go through the menu to create
the new MSQ...
declare your data sourse ie mdb, xls, other and from there you should be
promped to brouse to the data base. once selected, it should show the the
available tables and the available fields after that.

regards
FSt1



"Oldjay" wrote:

> Thanks that deleted the query but when I tried to setup a new query and got
> to Save query I got an error message "The MS Office access database engine
> couldn't find the input table "mdb.substrates"
> Make sure it exists and that it spelled correctly.
>
> It look to me that it should be looking for "substrates.mdb" but I don't
> know how to change it
>
> "FSt1" wrote:
>
> > hi,
> > are you using microsoft query????
> > if so then right click the query range and click data range properties.
> > on the property box, at the top, uncheck "save query definition"
> > chick ok. you will get a warning about permanently removing query. chick ok.
> > gone. non reversible.
> >
> > Regards
> > FSt1
> >
> > "Oldjay" wrote:
> >
> > > I have 2 sheets in a workbook that import data from an access on refresh. One
> > > works and the other one doesn't. I keep getting "disk error". I would like to
> > > delete the query and start over. How do I do this?
> > >

I already did all of that. Ihe error comes after I have finished all the
items in the wizard and click export to excel or Save query

"FSt1" wrote:

> hi
> not sure what method you are using but if you go through the menu to create
> the new MSQ...
> declare your data sourse ie mdb, xls, other and from there you should be
> promped to brouse to the data base. once selected, it should show the the
> available tables and the available fields after that.
>
> regards
> FSt1
>
>
>
> "Oldjay" wrote:
>
> > Thanks that deleted the query but when I tried to setup a new query and got
> > to Save query I got an error message "The MS Office access database engine
> > couldn't find the input table "mdb.substrates"
> > Make sure it exists and that it spelled correctly.
> >
> > It look to me that it should be looking for "substrates.mdb" but I don't
> > know how to change it
> >
> > "FSt1" wrote:
> >
> > > hi,
> > > are you using microsoft query????
> > > if so then right click the query range and click data range properties.
> > > on the property box, at the top, uncheck "save query definition"
> > > chick ok. you will get a warning about permanently removing query. chick ok.
> > > gone. non reversible.
> > >
> > > Regards
> > > FSt1
> > >
> > > "Oldjay" wrote:
> > >
> > > > I have 2 sheets in a workbook that import data from an access on refresh. One
> > > > works and the other one doesn't. I keep getting "disk error". I would like to
> > > > delete the query and start over. How do I do this?
> > > >