Automate export of CSV files from a MS Access database

£10-20 GBP

Opravljeno

Objavljeno

pred 7 meseci

£10-20 GBP

Plačilo ob dostavi

MS Access 365 I have a database Table containing the various details of English schools. I have a Query set up to export to CSV file all schools in all regions. This works OK; saving to the correct file, sorted correctly. I have saved the export steps as a 'Saved Export'. When run this also works OK. I also need to export to CSV files 20 or 30 subsets: NW region schools, SE region schools, SW region schools, etc., Primary schools, Secondary schools, Special schools, etc., etc. The 'Saved Export' files only work correctly if the original Query is altered to the specific subset criteria for each subset. The only way I can see this working is to have 20 or 30 different Queries; one for each subset. This seems to me a laborious solution to the problem. If the data Tables were in MySQL I believe I could easily construct a page of PHP insructions to whack out the 20 or 30 subset CSV files in a few seconds. I need advice as to how to do this in Access, maybe with Macros? or with SQL type instructions such as: Open file: filename="[login to view URL]"; Print to file fieldnames on first line; Select schools where region="SW" and type = "secondary" sort by "schoolname" ... and print to file; Close file; Thanks Paul Welbank (part of typical subset csv file attached) I don't need someone to code it; just explain how it can be done with Macros or SQL type instructions

Database Programming

Visual Basic

ID projekta: 37402552

Več o projektu

2 ponudb

Projekt na daljavo

Aktivno pred 7 meseci

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@malaymondal087

Hello Paul Welbank, I am writing to express my interest in your project. I believe I am the best candidate for this project for several reasons: Expertise in MS Access and VBA: I have extensive experience working with MS Access and Visual Basic for Applications (VBA). I am proficient in creating and managing databases, writing SQL queries, and automating tasks with VBA. Problem-Solving Skills: I have a strong ability to understand complex problems and devise effective solutions. In this case, I can help you export subsets of your data to CSV files in an efficient manner. Attention to Detail: I pay close attention to detail, which ensures that I can accurately select the correct subsets of data for each CSV file. Efficiency: I understand that you want to avoid a laborious solution. I can provide a solution that allows you to export all subsets with just a few clicks, saving you time and effort. Communication: I am committed to providing clear and regular communication. I will keep you updated on my progress and am always available to answer any questions you may have. I am confident that I can provide the solution you need for your MS Access database. I look forward to the possibility of working with you. worksample: https://www.freelancer.com/u/malaymondal087 [login to view URL] Best regards, Malay Mondal

£14 GBP v 2 dneh