sql 2008

i have 40000 records in excel sheet and i want to insert it into database . error occur after 2000 record , and it start from beginning . i want to resume it from 2001 and continue any method for resume in vba??

Hello, I would like to have a date field in Excel which is then used in my connection SQL query. I have found the advice in the below link but the problem with that is that it involves a stored procedure and also I have multiple date ranges...

hiii,, i want to know can we connect to Sql Server through Vba for inserting data into Sql pls help.. i want to store my excel data into database to generate reports from them... is it possible through vba.. pls guide me..

I am relatively experienced in VBA coding, but I am totally new in MS SQL server 2008. I am trying to export an Excel table like below to a SQL server: A B C D E 1 Name Year ID 2 Jill 2015 17 3 Jack 2012 13 4 Mike 1999 25 5...

Dear Expert, I am using below code to uploade data in SQL table, and it is working fine, i want to add one condition in this code, which is before uploade data in SQL Table it will check whether customer id already exist or not in SQL Table (Customers), if customer id is already there in SQL...

dear Expert i am not expert in programming but thanks to all to help me, i have one table with 5 field in sql table, one of the field having unique values(InvoiceNo), and every month i append this table by using import/export vizard from excel, and that excel having some new value and some old...

I use Excel to quickly create sql statements, and now I'm wondering how I can have them execute and drop the returned results in another cell. I can create the data connection, but when I set the command type to SQL it appears that I cannot simply reference a series of cells as the source of...

I have an spreadsheet which has Excel tables with team data on. On one page I'm using an MS Query with SQL to query these tables. Here's the original thread (If you really want to know)...

Hi, I am looking to connect to a Microsoft SQL Server 2008 db with VBA and pull data with SQL. I would be using Windows Authentication. I've tried googling but couldn't find any MS SQL SERVER 2008 specific guides on how to do so. I've found this but I am not sure I understand how it works...

I have a workbook that contains two sheets with two seperate queries. On the first sheet I have two cells desiginated to accept the values for the parameters. The first sheet accpets the values and populates the table correctly. The second sheet doesn't seem to accept the values and just...

I'm using Excel 2010 to pull data via a Worksheets ListObjects with an ODBC connection to a SQL Server. I haven't had problems with this till I ran into an empty record set. In the case of no records Excel continues to Refresh the external query and displays this in the bottom left corner of the...