C
charlie853
I am trying to link a table in Access. I have tried this two ways and both
ways are generating errors.
1. I wanted to link to an Excell spreadsheet that was created from a Query.
I tried to link it with Access and the error is the file can not be found or
it is not the right format. The spreadsheet does exist and it is the
correct format.
2. I tried to get this information by linking in Access via a Link Database.
I started the procedure linked to the company and the table selected ok and
I get a full spreadsheet of errors and a Message that the bookmark is
incorrect. Would someone please help me figure this out.
I need to extract information from a database table in Navision (i can do it
in excel no problem, but I can not link the excel spreadsheet to access
listed in #1) sort it by customer Id and produce results on a form.
Any help I can get will be deeply appreciated
Thanks
Thanks
ways are generating errors.
1. I wanted to link to an Excell spreadsheet that was created from a Query.
I tried to link it with Access and the error is the file can not be found or
it is not the right format. The spreadsheet does exist and it is the
correct format.
2. I tried to get this information by linking in Access via a Link Database.
I started the procedure linked to the company and the table selected ok and
I get a full spreadsheet of errors and a Message that the bookmark is
incorrect. Would someone please help me figure this out.
I need to extract information from a database table in Navision (i can do it
in excel no problem, but I can not link the excel spreadsheet to access
listed in #1) sort it by customer Id and produce results on a form.
Any help I can get will be deeply appreciated
Thanks
Thanks