Search results

Hi, Yes, that would also simplify it. Though, I have now found an optimal solution after looking around quite a bit. I can simply link access to the Excel file directly. Then, each day, I just put the latest status report into the folder and let Access append the data into the SQL Server table...

OK, I took a look at this and was a bit too complicated for me. Though, I did just discover that I can have access link to the excel file itself and then have it append the data to another table just fine without having to worry about the header row. Thanks.

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...

Hi theDBguy, Yes, this worked perfectly! In addition, I simply moved the autonumbering field to the last column and the paste went fine without any modifications of the Excel spreadsheet. The column order is consistent, so this competely solves this issue for me. Thanks for the help...

Hi theDBguy, Yes, I can attach a screen shot to show exactly what I am doing. Here is the screenshot: https://www.screencast.com/t/v3a5Hvvz If you want to paste directly from Excel into an Access datasheet, you have to include the header row in order to let Access know which columns go...

Hi theDBguy, Thanks for the quick response. Let me try to clarify... 1. I get sales data from Amazon in the form of an Excel file (which includes "." and "/" in the header row). 2. I clean this data by removing the "." and "/" from the header row. 3. I delete all data in my Access...

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...

OK. I see that the formatting isn't done on the table object itself (like I do on the graph object). So, by using the format function in the query for the chart, it solves the issue. Thanks.

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...

Hi, Yes, that would be fantastic to get in touch with him. The key questions for me is where the code should be placed and which lines I need to update with my information (server locations, file names, database names... etc) I don't have the knowledge of VBA to understand what this code is...

Thanks for the link. It isn't clear to me how to update the code. Is there an instruction on which part of this code should be changed and how? Thanks.

We recently moved to Sharepoint 365. That has messed with my overall use of SP for storing my current front-end and using a front-end updater on the end user's computers. This no longer works. My backend is in SQL Server. So, now I have to have the end users actually go to the sharepoint 365...

Thanks. Just trying to find the optimal solution :)

Thanks. I haven't tried text files. So, I will give it a try and see if that simplifies the process. Thanks.

Does this work if the front end is located on a website (Sharepoint 365 folder)? Thanks, Chris

Yes you are exactly correct. Though, now that I see it laid out like that, it is still probably easiest for the user to just paste the table in there. Otherwise, when they download the file, they would then have to navigate to even figure out where the file is and then we have all of the...

The main use is when doing an export from our ERP system SAP to Excel. Then, the excel report is pasted into the Access database datasheet. That's pretty much it. The Access database itself is using SQL Server as its backend. I have just wondered if this is really the best option. The other...

Hi, The reason I ask is because it is not I who is doing the import, but end users. So, they won't have access to the import wizard... or will they? No, I think they would have to know exactly which table the data was being imported into. Thanks, Chris

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...

Thanks for the tip. I will check out this code and see if maybe it is better than the one we have been using. Thanks!