0
votes
0answers
22 views

How to live-update query/view data for order-status update. MS Access [closed]

If anyone remembers File Express by Expressware (a DOS program), this is what I'm trying to replace. I need to create a database to keep track of different custom jobs. (This is not used to print ...
0
votes
1answer
27 views

What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?

I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...
2
votes
1answer
35 views

How to import Dates from Excel into Access with text in some cells?

I am attempting to import a date column from Excel into Access. The problem is that over the years, users of the Excel spreadsheet sporadically inserted text notes into this date column a few ...
2
votes
1answer
92 views

When importing an Access table into Excel, a look-up column is showing all values as numbers

I have a basic Access to Excel question that has me frustrated. I have two Access 2010 data tables. One is a list of managers. The primary key is a manager ID (which is an autonumber because managers ...
0
votes
0answers
64 views

Microsoft Access - how to show document location in quick access toolbar?

In Excel 2010, I am able to show the location of a workbook by adding "Document Location" to my quick access toolbar (this is found under "commands not found in the ribbon). This is shown in Excel ...
0
votes
1answer
95 views

Is there a function in Excel or Access to reshape a table to First Normal Form, or a way to do it in SQL?

Very often tables are presented in Excel files in a non-normalized form. I have one such table which I wish to take into (somewhat) First Normal Form using either SQL commands in Access or, ...
0
votes
1answer
40 views

Linking two entries in a list

I'm a keen DOTA 2 player. It's a 5-a-side team video game where you play one from a pool of about 100 heroes with different abilities and strengths and weaknesses. I often play team captain and it's ...
1
vote
3answers
27k views

How to Merge Data From Multiple Excel Files into a Single Excel File or Access Database?

I have a few dozen excel files which are all of the same format (i.e. 4 worksheets per Excel file). I need to combine all the files into 1 master file which must have just 2 of the 4 worksheets. The ...
1
vote
1answer
38 views

Export from Access to Excel, Bosnian char š not showing completely

I hope this is the right StackExchange forum for my question. I need to export a table from Access to Excel. It has all sorts of special characters in it. Ranging from é, à, ù to ß and finally š. ...
2
votes
1answer
211 views

Adding foreign keys from existing Access tables to imported Excel sheet

I have an existing list of personnel that I am trying to associate with an imported list of computers. Specifically, I want to replace the current columns listing the names of the personnel assigned ...
1
vote
1answer
278 views

Excel data doesn't update after data injection from an access db

Description of the situation: I have a access DB where I export data with the following command to an excel: DoCmd.TransferSpreadsheet The export works and the data is exported into an existing ...
0
votes
0answers
211 views

Using Hyperlink in Access to link to excel spreadsheet

I am trying to link a cell in a table in Access to some specific spreadsheets in an Excel workbook. I used the hyperlink and put the address like this "My%20workbook.xlsx#Sheet12!a1" , it work ...
0
votes
2answers
80 views

Combining two Excel sheets

I ship a lot of items to a lot of stores and I have two Excel sheets. I have one sheet showing how many items I have shipped to each store and another sheet showing how many I have sold in each store. ...
0
votes
1answer
175 views

visio excel link

I was wondering if is there any chance that I could connect visio with excel in dual link? ill try to be more specific. I already linked visio with excel, I mean, I edit properties in excel and when I ...
0
votes
0answers
93 views

advice on generating reports with Excel vs Microsoft Access

I have a Microsoft Access based tool that lacks the reporting capability I need. The tool is able to extract extract each table from its relational database as a separate CSV file. These files aren't ...
2
votes
0answers
96 views

Insert Excel Spreadsheet Into Word From Access Database

I have an Access database with Excel spreadsheets (files) linked to a field in each record. In Word, I have setup a mail merge which picks up the data from each record and I want to insert the ...
1
vote
1answer
155 views

Finding instances across multiple excel columns and rows

I am working in MS Excel 2007 with data regarding a series of forum posts. Each post is represented by a row of data that includes a unique ID for each post, the unique ID of the user that posted it, ...
0
votes
2answers
230 views

Find the different two Excel sheets when having identical row

I have two excel sheets with same column Names and Format. And it has one identical row(can use as Primary Key) id. I want to get the diff. table 1: id Name GPA ----+------+------- 1 | AA ...
1
vote
2answers
662 views

MS Excel and Access - which is better for reports?

Where I work, staff have just started to use a basic table in excel (1 October) to record sales which has about 10 columns (name, client, renewed, discount, paid etc). I record the data (total sold ...
0
votes
1answer
391 views

Excel 2007 table gets data from Access 2007 Table or Query

I have a table in an Excel file which has a connection to an Access Query. When I first create the table in Excel, the data comes in with exactly the same order as how I set up the Access query. ...
1
vote
0answers
104 views

Best approach to doing automatic analysis of sets of tags in Excel/Access/or similar?

I have a large set of open-ended responses to a survey (~10,000), and each has been assigned a set of tags representing what the person has said in the response. This data is sitting in an Excel ...
0
votes
2answers
83 views

Two Access fields into Word without delimitation

I have two fields in Access, FN and LN that need to be converted to word without being separated by anything except a space. For instance, John in FN and Doe in LN should appear as John Doe, rather ...
0
votes
1answer
834 views

How to import row data into Access when Excel does a date conversion?

I have an Excel worksheet that looks like this: MONTH WIDGET QUANTITY COST Jul-09 Widget1 1000 1.00 ... <repeat a few thousand times> ... I would like to ...
-7
votes
1answer
558 views

Is there an equivalent of Excel's DATE() function in Access 2007? [closed]

Is there an equivalent of Excel's DATE() function in Access 2007?
3
votes
2answers
3k views

Pass parameter from Excel to Access query

I have a Access (2010 but I've also tried Office 2003) database with a lot of tables, forms and nested queries which rely on data entered in a form, e.g. WHERE query1.year=[Forms]![Form1]![Text0];. I ...
0
votes
1answer
672 views

Import Paradox db to excel 2007

I have Paradox database (its a file ) which i like to import into excel 2007 but i dont know how. After doing some research i found that i can do this in Ms access when i try to import the database in ...
0
votes
1answer
255 views

Copy & Paste with Microsoft Office

I have 300 rows of data in a table with a single column ( Excel, Access or Word-table doesn't matter) and I want to resize it for printing. So the data will have size 25x12 instead of 300x1. Is there ...
3
votes
2answers
498 views

Copy paste character limits between Access and Excel 2007?

I'm trying to copy-paste a query result from Access 2007 to Excel 2007 but some text columns that appear OK in Access are "cut-off" when pasting to Excel. How to paste this correctly, avoiding the ...
1
vote
2answers
504 views

Creating a very detailed report using Excel and/or Access

I have a database/spreadsheet of information that I need to make a very detailed report from. My knowledge on Access is quite limited so I started doing a mock up of the Report layout in Excel and ...
1
vote
1answer
1k views

Convert Access Form to Excel

I have an Access file that has 4 tables. How can I convert one of the tables to an excel spreadsheet?
1
vote
1answer
6k views

Windows 7 (64-bit) compatibility of VBA/Excel and Access applications

I am currently investigating the possible issues when migrating from Windows XP 32bit to Windows 7 64-bit. The scope is MS Excel (32-bit), MS Access (32-bit) using VBA/Macros addins, ODBC and all ...
0
votes
1answer
277 views

Total an access database by quarter?

I'm looking for a way to split a large block of data in access into quarters and then total all of the data by quarter. I know how to generate a report and have it break everything off into quarters ...
0
votes
2answers
612 views

Condensing and grouping results from a database in Access or Excel

What I have to do is take the results from a database, and condense them all into one line per date. Right now, each date has numerous amounts of rows, and the data I need is spread throughout each of ...
1
vote
1answer
569 views

Excel 2003 to Excel 2007 performance on large files

We have a user that uses Excel 2003 for a few of their acturial formulae. At the moment they are using a ESX host VM with 2 gig of RAM and a single core. The issue is that their huge burgeoning ...
0
votes
0answers
160 views

Retrieve selected groups of field from an Access table using VBA

I am using VBA to connect Access DB to Excel. I want to select a specified group by default. How would I select the specified group fields in the table if I am unsure about their field names?
0
votes
2answers
583 views

Apply or include Excel sheet template in Access MDB

A colleague of mine organizes her data using MSAccess. she outputs the table and pastes it into an excel file (same headings/ columns,,,,). The excel sheet then does some calcs and outputs a summary ...
0
votes
2answers
878 views

Change SystemDSN to FileDSN for 100's of MS Access and Excel Files

A particular team in my office uses 100's of Microsoft Access Models. They all connect with the database using SystemDSN and, the name of the SystemDSN is hardcoded in the Microsoft Access Models. My ...
0
votes
1answer
51 views

Script for preriodic emailing to a list of addresses from an Excel/Access DB?

I'm looking for a program/script, better if it's OpenSource/Free, that can periodically send an email to a list of addresses that are in an Excel File or Access DB. I know I could hack something ...
2
votes
2answers
2k views

Equivalent of Excel's NETWORKDAYS function with Jet ADO

Is there a way of replicating Excel's NETWORKDAYS when connecting to a Jet database via ADO?