Join 3,555 readers in helping fund MetaFilter (Hide)

35 posts tagged with access and excel. (View popular tags)
Displaying 1 through 35 of 35. Subscribe:

Merging Duplicate rows in Excel or Access

I have a table with duplicate values in one column. Some of the other columns have a value, some don't. I want to have one row for each record, with all of the colums values in one row (NOT CONCATENATED). I can use Excel or Access for this. [more inside]
posted by desjardins on Jun 19, 2014 - 18 answers

Looking for an advanced Excel/Access crash course

VBA and Macros and VLookup, Oh My! I might be ending up on a work assignment where they want someone who can create and edit complex Excel templates that interface with Access and Adobe Forms. I've used all these programs extensively, but I've only used advanced features sparingly (either editing someone else's creation or googling for a specific fix for a specific problem.) Difficulty level: I only have a week to cram on this before I would start. Is it possible for a quick learner to get up to speed enough not to crash and burn on a project like this? Can anyone recommend an online course I could binge on before having to take on this project?
posted by firechicago on May 19, 2014 - 2 answers

Convert rich text field in Access or Excel into plain text

I have thousands of rich text message message fields currently formatted in RTF (rich text format) that need to be stripped of their formatting and converted to plain text. Currently the field is in a Microsoft Access database. But if needed, the database could be sent to Excel if that would ease the conversion of the RTF to plain text. [more inside]
posted by Jackie_Treehorn on Nov 12, 2013 - 16 answers

Changing manual timetabling to electronic

I receive timetabling data in Excel spreadsheets and want to map it out automatically, rather than working out the timetable/grid by hand every time because the data changes, and I'd also like to filter it to show certain groups - teacher for example. [more inside]
posted by b33j on Oct 14, 2013 - 5 answers

Access Training similar to Excel Everest?

Is there a good Access training option where you learn it by working in the program interactively rather than just watching videos or reading text?
posted by ewiley28 on Jul 25, 2013 - 2 answers

Looking to extract more info from this database

We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
posted by Admira on Jul 17, 2013 - 11 answers

Comma delimited list to multiple lookup values in Access 2010

Is there an easy way of turning a comma-separated list into multiple lookup values in access 2010? [more inside]
posted by monkey closet on Dec 14, 2012 - 1 answer

Seeking on-line training in MS Office

Seeking recommendations for on-line training on business applications, particularly MS Office. [more inside]
posted by dg on Sep 4, 2012 - 8 answers

Excel keeps unreferring my references

Excel 2010 query using data from MS Access: refreshing the query screws with my cell references. Help me make it stop. [more inside]
posted by jeather on Apr 18, 2012 - 2 answers

Need some pointers on creating a simple inventory database

Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]
posted by smoothvirus on Feb 22, 2012 - 8 answers

Match multiple columns in excel/access

I'm trying to merge multiple month's worth of data into one master spreadsheet with a master column on the left, and individual month's counts on the right. My data is laid out as such: [more inside]
posted by thankyoumuchly on Sep 8, 2011 - 3 answers

I don't think Fortran and punchcards cut it anymore...

Which programming languages are best suited to creating a timetabling application? [more inside]
posted by bister on Jun 26, 2011 - 16 answers

How can I more easily edit CSV tables in Access or Excel?

I make mailing labels by pulling information about specific real-world locations into small database files. I used to get MS Access-ready DBase files, but now I have to work with CSV files, which don't seem to play well with Access. Please help me get more use out of Access, find out how to convert CSV to DBase or similar file types, or figure out better ways to use Excel. Long version inside. [more inside]
posted by filthy light thief on May 16, 2011 - 7 answers

How can I reformat some rows into columns in Excel?

How can I reformat some rows into columns in Excel? [more inside]
posted by teg on Dec 6, 2010 - 14 answers

Microsoft Acess Charts dead-end.

Microsoft Access 2007 - how on earth do I cut / copy / export / do anything with my Pivot Chart, besides print it? [more inside]
posted by Jimbob on Nov 23, 2010 - 12 answers

Analyzing Surname Data

I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature. [more inside]
posted by angelaas525 on Jul 9, 2010 - 4 answers

Please help a data analysis amateur!

How to sort to count yes/no answers.... In Access or Excel. Help! [more inside]
posted by BusyBusyBusy on Jul 6, 2010 - 16 answers

Can you recommend online tutorials for Excel, Word, and MS Access?

Can you recommend online tutorials for Excel, Word, and MS Access? [more inside]
posted by helios410 on Feb 10, 2010 - 8 answers

MacgyverFilter: link sharing using MS Office

Macgyver IT: I want my team to use something like del.icio.us to share links. But since this is ask.metafilter, I can't use the obvious right answer. I need to make something like it myself, using bubblegum and string the MS Office 2000 suite and my knowledge of VB. What would be my best approach? [more inside]
posted by Monday, stony Monday on Nov 19, 2009 - 7 answers

Serious help needed with Excel

Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside. [more inside]
posted by TheBones on Aug 11, 2009 - 17 answers

Can I do this in Excel and/or Access? Explained inside

Can I do this in Excel and/or Access? 'This' is a bit complicated so it's explained inside. [more inside]
posted by nooneyouknow on Jul 17, 2009 - 13 answers

How to extract data from HTML

How to extract data automatically from a group of HTML pages to an Excel file or to a database? [more inside]
posted by elgilito on Apr 22, 2009 - 5 answers

Timeline Charts on Steroids

I am tasked with preparing a multi-category, filterable timeline as a work project. I think Access is probably the best way to do this, but I need some help with the mechanics, or suggestions on where to find a template. [more inside]
posted by Inkoate on Oct 11, 2008 - 1 answer

How to run a query in Excel 2007?

How do I group values by a variable in Excel 2007? Essentially, I want to run a query. [more inside]
posted by desjardins on Jan 25, 2008 - 8 answers

Just a little bit of help with Access...

I've been asked to create a software facility through which a nurse can print medicine dosing cards for patients. [more inside]
posted by dance on Nov 5, 2007 - 2 answers

Help me chose books for Access and Excel!

I need recommendations of some books for Excel and Access. I'm looking for something referency, but still readable. [more inside]
posted by chrispy108 on Oct 8, 2007 - 6 answers

Help me merge Excel with Access:

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted by 2bucksplus on Jul 2, 2007 - 3 answers

How do you create text files from a spreadsheet?

How do you create text files from a spreadsheet? [more inside]
posted by bigmusic on May 2, 2007 - 6 answers

How do I get my table rows to stay clumped in fives?

How do I get a the rows in a table to stay clumped in fives even if I add or change the data?I have a long list of data that I need to arrange in a table, and I want the rows grouped together in fives. I'm currently working in Microsoft Word, and what I've got looks something like this Google Doc. I want the table(s) to stay grouped like this even if I add, delete, or change the data. If I just use the Word tables, adding a new line to a group will just create an extra row. [more inside]
posted by bokinney on Mar 12, 2007 - 7 answers

How do I create PDF forms from Access/Excel data?

I need to generate fillable PDF forms with calculations from an Access db or Excel spreadsheet. [more inside]
posted by elle.jeezy on Jan 3, 2007 - 3 answers

Error When Exporting Access Report to Excel

Some colleagues are trying to export a MS Access report to Excel. Here's the error they get: [more inside]
posted by ao4047 on Nov 6, 2006 - 4 answers

Champagne scheduling app on a beer budget.

OfficeApp Filter: How can I seamlessly convert lists of project assignment names and deadlines to a calendar view that can be shared? Or can I? [more inside]
posted by Marnie on Aug 22, 2006 - 4 answers

Carriage Returns in Excel

It's not how I'd choose to spend my Friday evening, but for the last few hours, I've been trying to replace carriage returns that have turned up in an Access and Excel file, and drawing a blank. [more inside]
posted by godawful on Feb 10, 2006 - 9 answers

DatabaseFilter: Linked tables

Database 101... I have two tables, with one common field, an ID number. One table has many more records than the other. How can I tell which records in the 'big' table are also in the 'small' table? [more inside]
posted by clgregor on Sep 2, 2005 - 5 answers

How do I push Excel data into Access records?

I have a mountain of data to move from dozens of Excel spreadsheets into an Access database. The database is an existing one and sort-of documented. How do I go about doing this? I’m very comfortable with Excel, but not at all with Access---I’ve never used it before. How do I push Excel data into Access records? Are there any web resources I could use? Any books I should buy?
posted by bonehead on Aug 19, 2004 - 10 answers

Page: 1