Tagged Questions
1
vote
0answers
37 views
VBA PasteSpecial does Partial Paste
thank you in advance for taking your time to help me out,
I currently have a loop running which selects a range, copies and then pastes the values in the required columns.
Set ...
0
votes
2answers
17 views
Exporting data from Access to an Excel Spreadsheet
I'm designing an app that helps record data since currently it's done with paper and then typed into Excel at the end of the month. Now, I've made it through all of the app design and am working on ...
-3
votes
1answer
25 views
Import a range of cells from an Excel file into MySQL [closed]
I have some Excel files and every end of month I will have those Excel files to calculate expenses and revenues. The issue is that the accounting department sends me Excel files that are is too much ...
2
votes
3answers
35 views
How to delete duplicate and original entries in either access or excel (multiple columns)
Is there a way to delete all duplicate rows and the original entry in either excel or access?
I need to delete whole rows that match in 3 columns. Here is a visual (Bottom table is what the table ...
1
vote
2answers
67 views
How to avoid “Numbers stored as text” when exporting to Excel
When I export a table from Access to Excel, all the numbers show up as text, and have that green arrow on the cell. Is there a way to automatically fix this error, or another way to export that works ...
-1
votes
0answers
30 views
Integration of Excel and Access [closed]
This is a general design question, not a specific code issue. I am integrating Access and Excel segments into a single application - basically, Access will store the data, keep the historical ...
0
votes
1answer
28 views
Picking a database solution for an Excel UI?
I am building a small application on Excel using VSTO (Visual Studio Tools for Office) Visual Basic and currently building the UI on excel and the functions with in it. However, the application itself ...
0
votes
0answers
56 views
Run time error 462 - server machine is unavailable - when Excel from Access VB script
I am automating a process with a mix of Access and Excel, with the VB scripts running in Access to use Excel workbooks. I frequently get runtime error 462 "The remote server machine does not exist or ...
1
vote
1answer
52 views
Counting Records With Spacial Condition
I have many Excel files which contain records of many schools students like...
Name | Father Name | Class | Section | Address | Image Path | Mobile No. | House Name | Gender etc...
So I want to ...
-4
votes
0answers
33 views
microsoft access quiz(examination test) application [closed]
I need to develop quiz(examination test) application on ms-access and\or excel.
Main functions of application
Manage questions database (with answer variants and right answer)
Run test with random ...
2
votes
3answers
42 views
How can I identify the text values that have the lowest row IDs across 4 columns?
I found a few articles that are close, but not the same as what I am trying to do. I have an Excel file that has 4 columns of duplicated data, each column is sorted based on a numeric value that came ...
2
votes
2answers
51 views
SQL Query in Excel gives “undefined function name” error
I wrote a SQL query in MS Access that uses the MonthName function. In access it works flawlessly. I copied the exact SQL statement into an excel module that I frequently use to query databases. ...
-1
votes
0answers
31 views
how to change two columns into many more based on data in first column
I have a table with some columns and would like to divide it / transpose automatically somehow, but I have no idea where to start.
The input table looks like this:
NAME CODE1 CODE2 ...
1
vote
1answer
392 views
Mass Import Data from Excel file to Access programmatically in C#
Given the fact that Excel and Access are compatible in some level, is there a way to import data from an excel file to an Access Database programmatically, without reading the file and inserting data, ...
3
votes
2answers
8k views
stop Ms Excel auto-formatting numeric strings as numbers
I am exporting a report from MS Access(2003) to Excel (97-2003) output.
One of the columns has a character string that is numeric for some rows e.g. "05-0880".
When I open the output file in MS ...
