All Questions
3,200
questions
0
votes
0
answers
23
views
Compile Error when opening an Excel spreadsheet from Access
I have various routines within an Access database system that open Excel, open a workbook, make changes before saving it, closing it and quitting. Basically, I use this code:
Dim objExcel As Excel....
-1
votes
0
answers
52
views
Unable to Locate "Sheet1" in Excel File When Using pyodbc to Insert Data into MS Access
I'm trying to insert data from an Excel file into an MS Access database using pyodbc, but I keep encountering an error stating that "Sheet1" cannot be found in the Excel file. Here's my code:...
0
votes
0
answers
34
views
Python Error : [42S02] [Microsoft][ODBC Microsoft Access Driver] The Microsoft Access database engine could not find the object 'Sheet1$'
For some reason with what I am trying I cannot get to find the excel Sheet1. Here is my code:
filename = 'ALC_2022068_06282024-testing copy.xlsx'
sql = r"""INSERT INTO tblALC_test ([...
-1
votes
0
answers
37
views
Why is my query not populating in MS Excel from Access? [closed]
Hi, I am trying to pull my queried data into an excel file but unfortunately it is not populating in excel even though there is data in the access queried table. Any fix to this?
I have tried ...
0
votes
1
answer
47
views
Run Excel macro in personal.xlsb from Ms Access
I made code in ms access to create an excel file with MS Access data. This work fine, but when it has been created I want to start an Excel macro that is stored in personal.xlsb. Is this possible? I ...
0
votes
0
answers
46
views
Excel vba Nested Forms Listbox missing data
I'm using multiple forms in excel vba and each form for itself works nicely.
I've created frmMainMenu to call these forms and whenever I call some of them, listboxes in them are not filled with data.
...
0
votes
0
answers
52
views
Edit Excel file from MS Access using vba
I have a MS Access database that exports a queries as sheets to an excel file. Then (this is the part where I'm getting stuck) it is supposed to open the newly created excel file, apply conditional ...
0
votes
0
answers
39
views
Excel Power Query, Passing Parameter to MS Access Query
I am trying to pass a parameter to an MS Access query, in Excel Power Query.
I have a query in Access which takes a Single parameter called View that acts as a switch to filter the data, such that I ...
0
votes
0
answers
45
views
Export Redshift data to Microsoft Access
I have my application data directly saved in Amazon Redshift. Now I want to directly import that data in Microsoft Access for internal working. How can I achieve this?
Currently I'm using Excel as a ...
0
votes
0
answers
46
views
in VBA objXML.loadXML(strXML) thows error "DTD/schema not valid"
I think the answer of the endpoint is not fully loaded by objXML.loadXML, so there is an error "problem with DTD"
I try to read an api. it works fine with postman, header and XML looks ok
...
0
votes
1
answer
76
views
Design MS Access SQL Query to mimic 'Remove Duplicate' Excel function
In MS Access 2016 I want to run a query that is synonymous with the Excel 'Remove Duplicates' function.
The excel query will remove duplicates and always leave one record.
For example, if we have 4 ...
0
votes
0
answers
35
views
Make Table Query and Linked excel file [duplicate]
I have an Excel file that is updated regularly I.e. Every minute, and I have linked this file to a table in MS Access. This works great. However, I cannot index my key unique field, and therefore, I ...
0
votes
0
answers
63
views
DateTime to Date in Excel from MS Access and SQL Server datasources
I inherited a very old project. Currently, there is a MS Access 2019 database. This database has a DSN to a SQL Server database. There are cross tab queries in MS Access that pull data from SQL Server,...
-1
votes
1
answer
117
views
Export Access report to Excel file that will hold the report formatting
I need to export an Access report (that's already summarized a query).
The report has an unbound form that filters by a date range.
The form also has a Payment Date field (so it will post a Payment ...
0
votes
1
answer
171
views
How do I read data from an old Access .mdb file with Excel 64-bit
Have an old Access 97-version .mdb file
I read the data from VBA in Excel 32-bit with the connection string "Microsoft.Jet.OLEDB.4.0"
Now Excel has been updated to 64-bil version and the ...