Search results

  1. C

    Direct import of Excel spreadsheet into Access

    Hi, I get a daily Excel status report. The header in this report includes a "." dot. I want to import this data into Access each day. What is the best way of doing this? (I posted a different post on pasting it directly, but see that having to replace the "." manually each day in...
  2. C

    Pasting Excel into DataSheet

    Background: For many years, I have used datasheets as an easy way to paste right from Excel into Access (SQL Server). Though, I have to always remove "." and "/" from the header row each time to make this work. Question 1.: Is there a way to get around having to clean "." and "/" from the...
  3. C

    Changing format in data table below chart object

    Hi, I have a chart object with a data table below the chart. I want the revenue figures in the table to be in "standard format" or "# ##0". Currently they are showing figures like: "4036" and I want "4 036". I found I can edit the object by right clicking on it and then making it the correct...
  4. C

    Easiest way to get Excel table into Access

    Hi, I have for the past several years just used a datasheet to pull in data from Excel into Access. However, I was wondering if there is a better way to do it? The advantages I have seen is that if the columns are dirty in Excel, the user will get an error. Also, the end user can see...
  5. C

    Front-end updater on SharePoint Online?

    Hi, For the past several years, I have used the following front-end updater: "Application Starter for Microsoft Access (versions 2000 and later) Version: 4.4" http://www.peterssoftware.com/aps.htm My database has an Access front-end and MS SQL Server backend. I have had the front-end stored...
  6. C

    Subform linking to SQL Server View

    Hi, I recently discovered that I have been making a design mistake when using SQL Server views. I previously would have a view and allow the user in an Access form to change data in the view. However, I learned that this is not a good solution. A better solution is to have the user make their...
  7. C

    Connecting To SQL Server Local Instance

    Hi, I have been using a local SQL Server 2012 Instance which I link to using the below VBA code. Everything has been going fantastic for years until I upgraded my computer recently. I installed a local instance of SQL Server 2012 on my computer and then imported the database that stores the...
  8. C

    Queries in Access to Views in SQL Server

    Hi, I have been using access for several years now and am getting up to speed in SQL Server now. In Access, you can create a new column that is based upon other columns in the table. Then, within the same query, you can use the new column as a basis for a new calculated column and so on. My...
Top Bottom