+ Reply to Thread
Results 1 to 2 of 2

Changing Excel DB to SQL Database

  1. #1
    Forum Contributor
    Join Date
    06-25-2018
    Location
    South-Africa Pretoria
    MS-Off Ver
    2016
    Posts
    116

    Changing Excel DB to SQL Database

    Greetings
    Trust all is well,

    I was wondering if someone will be able to assist me based on Moving my data that is currently writing in Excel to a SQL Database.

    I made a Update form with Multiple Functions based on data that gets populated within the same sheet using a Userform.

    I now need to move my data to a SQL DB as the data is becoming to much for Excel.

    My concern is that I have never done VBA Coding to actually write data to a SQL DB.

    I am Currently Researching the methods to try and figure it out myself but seem to struggle finding a way to Write my data to SQL as well as matching/Finding data in SQL DB to either update the row or add a new Line to the DB.

    My Code is attached within a .txt File as it is roughly 1400 Lines of Coding.

    My File is also attached.

    Few Point in order to know how to operate the sheet and form

    With Sheets Dashboard click the User Form Button to Open User Form.
    Complete Form From Top Downwards starting each line from the right.
    Site Id to be "1234" as an example
    Click "SITE ID" Label ( Button ), and it will lookup to see if the Line can be found based on the "TYPE OF FEEDBACK" Selected.
    Click "STATUS CHECK" Button once all fields has been completed.
    Update Database if Changes has been made.

    PASSWORD IF NEEDED IS "123456"

    Form will be auto populated based on the lines if available.

    I want to be able to move all Tabs to SQL DB and only have the Dashboard Tab Available for users to use.

    I will Appreciate if Someone could assist me with this. Evan if Guideline can be given based on searching Data FROM SQL DB Instead of an Sheet.
    Each Tab Should be its own Table.

    Basically for Retrieving and Writing part to the SQL DB ( Mostly from Line 867 within the .txt file Downwards and From line 103 to 248 )

    I am aware of some Minor Query's for SQL based on

    Select * (dbo.Alarm_Installation)
    Where SiteID = 1234 and Completed = N'Yes'

    Minor Queries to Retrieve data from SQL Using MSSQL.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,011

    Re: Changing Excel DB to SQL Database

    if you have Access, you only need to run an append query to add the data from excel to SQL.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Changing Access Database table in excel
    By dummy777 in forum Access Tables & Databases
    Replies: 14
    Last Post: 03-21-2019, 07:42 AM
  2. Replies: 7
    Last Post: 10-17-2018, 04:27 PM
  3. MS Query connection changing database location
    By Kburges in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-02-2013, 06:39 PM
  4. changing a database list
    By thedragon in forum Excel General
    Replies: 3
    Last Post: 10-30-2011, 08:50 PM
  5. Changing file name for database reports
    By mhig9000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-20-2010, 05:08 PM
  6. Changing a link for an Access Database
    By bullwinkle55423 in forum Excel General
    Replies: 3
    Last Post: 02-02-2008, 02:05 PM
  7. Changing access database location
    By jerredjohnson in forum Excel General
    Replies: 2
    Last Post: 01-16-2007, 08:31 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1