Search results

I have two tables. Table1 is updated once a month. I have added a date field named "last_pull". I am attempting to populated that field with data from Table2. Table2 has two fields - an autonumbered "ID" field and a "pulled" field. The pulled field is a record of all Table1's update dates. The...

@arnelgp - I finally got a chance to use this and it works great. Thanks for the help with this!

Thanks for the replies guys. @arnelgp - I played with what you sent me and it worked on doing a quick test. I have something else I need to get done before a meeting tomorrow so I will not get a chance to do anything with this until after that.

I did that and have the code but do not how to use it in VBA. Yes I did that before I posted on here.

After you posted that I did the import and saved the steps. I tried using DoCmd.RunSavedImportExport but still had a problem. The Excel file has has multiple sheets so it would need more steps to convert it to a CSV. I found this here and tried this with one of options listed about 3/4 of the...

I went to try your idea and Access. When I import a text file there is an Advanced option that lets me save the import specs I have set up. I am not seeing that when I import an Excel file. All I have is the "Save Import Steps" at the end. Would this be the same thing?

I use the data in the Excel to build (7) individual data sets that are used as load sheets to get our data into another system. I have a macro set up that runs all the code/queries to get it done. I am looking for something that can be added to that macro so it is done automatically. I do not...

That sounds like a plan. Would it require : - "blanket" code that automatically looks at each column and adjusts as needed - Individual code be written for each one of the (90) fields There is nothing here. When I say nothing I mean there is no leadership. There are no...

Good morning all. There is an Excel file that was created and is maintained by multiple coworkers. I have to work with the data in that file so I currently have it as a linked table in my Access db. I ran my query and found empty cells where there should be data. Looking at the linked table I...

I have no experience exporting/building an XML file from Access. I am also not an Access wizard. I am looking for specific and hopefully easy to follow instructions on how to do what I need to do.

I did some of the tag pairs in Notepad and saved it as an XSD file but I am not sure how to "connect" the two. When I use Access's export feature I am not seeing where I can select my own schema.

Good afternoon. I use a program that builds a data set in an Access db and then converts that data into an XML file. I modify the data in the Access db and then go into the program and run out the XML file. I have to do this multiple times as we need different XML files. The XML file is in a...

It is not bad data. These are vehicle makes and models. It is also includes offroad/aggricultural/industrial stuff such as generators, combines, backhoes, whatever. It is a pretty wide array of stuff so there are going to be variances in the model names. We also use our own custom names at...

It is not consistent and as we add more data the patterns could keep changing so I figured out another way to link to our Make and Model tables.

I am all set. I did not figure out how to split them up but I did figure out how to link the data to our Make and Model tables and get the data that way.

I have some data in a field. It is basically Make and Model data. Some fields have vehicle type added in: AUDI-RS5 / RS5 SPORTBACK VOLVO - TRUCKS - MEDIUM / HEAVY DUTY-VNM SERIES WHITE - TRACTORS-2-110 CASE - EXCAVATORS-688B CK I would like them to be separated into two different Make | Model...

Thanks for the replies guys. I changed up some of the queries so they use less resources and it has been running fine. If I have the issue I will add the MakeCodeWait sub. One question I do have is when you get an error like that is there a way to know if the coding is bad vs too many...

The workbook is not already existing. It is created by the first TransferSpreadsheet function. They are not really that big or complex. When you run them in Access they open right up. Each query has one calculated field where it is calculating the sum of some fields in a table. The Excel...

Option Compare Database Public Function ExportToExcel() Dim strPath As String strPath = "C:\Users\MyName\Desktop\fi_cv_polk_" & Format(Date, "mm_dd_yyyy") & ".xlsx" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "42_aces_detail_no_ids", strPath, , "vio_by_aces_apps"...

I created a function to export five Access queries out into five sheets in the same Excel 2016 workbook using: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "QueryName", C:\Path\ExcelFileName, , "SheetName" Sometimes I run it and it runs fine. It creates the workbook and...