Permissions problem connecting to SQL Server with Excel and VBA

Connecting to SQL Server with Excel and VBA could be a permissions issue and the user should first ensure the login is mapped to a valid database.

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

I am attempting to connect to SQL Server with Excel 2003 and Visual Basic for Applications (VBA). The connection works (using Data Access Objects) for reading data but not for adding tables and fields or writing data. Please advise me on how to proceed.

This sounds like a permissions issue. Make sure the SQL Server login is mapped to a valid database user with the necessary permissions. If the user should have access to all tables in the database, the easiest solution may be to give the user access to the db_datareader and db_datawriter fixed database roles. The datareader role allows the user to read from all tables in the database. The datawriter role allows the user to create new tables, and manipulate data in any existing table in the database.

This was last published in May 2006

Dig Deeper on SQL Server Interoperability

All
News
Get Started
Evaluate
Manage
Problem Solve

CORBA (Common Object Request Broker Architecture)

SQL Server 2014 features enable hybrid cloud scenarios

Related Q&A from Adam Machanic

Stored procedure concurrency problems in SQL Server 2005

Multiple readers can sometimes read the same row simultaneously causing a false result. SQL Server 2005 expert Adam Machanic suggests modifying the ... Continue Reading

Upgrading SQL Servers

Migrating to SQL Server 2005 from SQL Server 2000 is a hefty feat when compared to upgrading from 7.0 to SQL Server 2000. Site expert Adam Machanic ... Continue Reading

SQL vs. T-SQL

SQL Server 2005 and T-SQL do have differences. The advantages and disadvantages would depend user environment as described by SQL Server 2005 expert... Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Tableau Ask Data gives BI users simple NLP data query tool

Tableau's new Ask Data software uses natural language processing to enable users of any skill level to more easily search for ...

Expert urges data pros to hone data science skills

IT expert William McKnight shares job tips for data professionals looking to prosper in a changing enterprise. His first piece of...

Demand for data scientists is booming and will only increase

Fueled by big data and AI, demand for data science skills is growing exponentially, according to job sites. The supply of skilled...

SearchDataCenter

How to prepare your data center for an HCI appliance

Vendors tout hyper-converged infrastructure as a plug-and-play offering, but before you install anything in your data center, be ...

Hone these top 5 data center skills in 2019

As data centers become more software-based, admins should prepare themselves by learning about the cloud, containers, DevOps and ...

Carbon Relay debuts AI-based software for data center cooling

Newcomer Carbon Relay has introduced two products that use artificial intelligence to help IT pros manage data center efficiency.

SearchDataManagement

Originators form group to boost Presto SQL query engine

The Presto engine arose as an alternative to Hive for big data queries. Now, the Presto Software Foundation has formed to promote...

5 best practices for managing real-time data integration

Real-time data integration isn't like traditional data integration -- "it's moving, it's dirty and it's temporal," cautions one ...

Web integration platform eases way to machine learning models

StoryFit data scientists employ machine learning algorithms to gauge film script scenarios' prospects. They use Import.io tools ...

SearchAWS

Use AWS Firecracker to build micro VMs for containerized apps

Firecracker has many of the benefits of containers and VMs, without some of their limitations. Here are a few things to know if ...

AWS Lambda functions become more flexible, but use caution

AWS Lambda added custom runtimes and longer timeouts. Review the benefits, such as flexibility and easier migration, along with ...

AWS' blockchain approach takes divergent paths

AWS was slow to embrace blockchain but now offers two approaches to the concept. Review the specs of Quantum Ledger Database and ...

SearchOracle

Click-to-launch tools pull apps through Oracle Cloud Infrastructure marketplace

Oracle has made it easier for customers to choose and launch third-party software onto its cloud. Now, the question is whether ...

Rewards program provider taps Oracle IaaS for app migration

Oracle struggles in IaaS against AWS and Azure, but one Oracle cloud customer said its move there is a success, albeit within an ...

Future of Oracle centers on the cloud, AI and automation

Oracle deepened its embrace of cloud computing, AI software and IT automation tools in 2018. What can users expect from it in ...

SearchContentManagement

Personalized content solidifies the customer experience

Today's customers expect customized, curated digital experiences. Learn how to deliver what customers need and stay ahead of the ...

Create a winning personalized customer journey

Web content management platforms, customer data platforms and matchmaking can all help companies create and implement a ...

Google, WordPress develop a CMS for news

Google is funding a WordPress-based content management system aimed at helping small news publishers juggle the demands of ...

SearchWindowsServer

Microsoft zero-day vulnerability closed on Patch Tuesday

Administrators should prioritize patching systems affected by a zero-day vulnerability resolved by the February Patch Tuesday ...

How to configure SSL on IIS with PowerShell

SSL encryption is a necessary component when building an IIS website that communicates with the outside world. Use this ...

How well do you know open source PowerShell Core?

Do you know how PowerShell Core differs from Windows PowerShell? Find out with this quiz on the open source PowerShell management...

SQL Server 2014 features enable hybrid cloud scenarios

Scale out with Windows Azure SQL Database

Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases

Utilize SSAS for data predictions and classification using Excel

Cloaked in secrecy, Microsoft project aims to wed SQL, NoSQL databases

Data integration woes here to stay

CORBA (Common Object Request Broker Architecture)

SQL Server 2014 features enable hybrid cloud scenarios

Tools and technique to move SQL Server data to Oracle

SQL Server 2014 features enable hybrid cloud scenarios

Scale out with Windows Azure SQL Database

Utilize SSAS for data predictions and classification using Excel

Microsoft Access 2007 integration with SQL Server

SSIS package to filter false records

Please create a username to comment.

Tableau Ask Data gives BI users simple NLP data query tool

Expert urges data pros to hone data science skills

Demand for data scientists is booming and will only increase

How to prepare your data center for an HCI appliance

Hone these top 5 data center skills in 2019

Carbon Relay debuts AI-based software for data center cooling

Originators form group to boost Presto SQL query engine

5 best practices for managing real-time data integration

Web integration platform eases way to machine learning models

Use AWS Firecracker to build micro VMs for containerized apps

AWS Lambda functions become more flexible, but use caution

AWS' blockchain approach takes divergent paths

Click-to-launch tools pull apps through Oracle Cloud Infrastructure marketplace

Rewards program provider taps Oracle IaaS for app migration

Future of Oracle centers on the cloud, AI and automation

Personalized content solidifies the customer experience

Create a winning personalized customer journey

Google, WordPress develop a CMS for news

Microsoft zero-day vulnerability closed on Patch Tuesday

How to configure SSL on IIS with PowerShell

How well do you know open source PowerShell Core?

Related Resources

Dig Deeper on SQL Server Interoperability

Related Q&A from Adam Machanic

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.