Question : THIS IS A THEORETICAL QUESTION. I am posting it on this site because of this and because I […]
Tag: vba
Best way to enter data in DB that is spread out date wise
Question : I have an Excel file that, to keep it simple here, has 3 columns: ActivityID, ActivityName and TotalHours. […]
Get value from one field, and paste it in to a new column
Question : I’m relatively new to Microsoft Access, and just a beginner with SQL programming. I have a table in […]
How can I setup and use a PostgreSQL database without installing a driver?
Question : I have a portable PostgreSQL database that runs perfectly on my computer as a database server. This is […]
Inserting ID and Date to locate data for C#/VBA application
Question : I am trying to allow users to upload an excel sheet to insert data into the sql database. […]
Transfer datas from Access to PostgreSQL
Question : I’m trying to insert some data from Access to PostgreSQL database, but it’s not a simple query, because […]
Visual Studio extract database values to excel with header text!
Question : I am trying to extract the values from an mdf database to excel, but i can’t display the […]
Concurrent connections to the same table
Question : We are a small firm, with about 10 people using a database server. I have this application that […]
MySQL/MariaDB connection in asp code encodes wrongly charset utf8 at insert or update in data base
Question : I can’t get a simple update or insert to save special äöü characters. Instead they are being stored […]