What is the advantage of selecting the “Only Create Connection" option when importing data?

Accounting Information Systems
10th Edition
ISBN:9781337619202
Author:Hall, James A.
Publisher:Hall, James A.
Chapter2: Introduction To Transaction Processing
Section: Chapter Questions
Problem 33RQ
icon
Related questions
Question
What is the advantage of selecting the “Only Create Connection" option when importing data?
What is the advantage of selecting the
"Only Create Connection" option when
importing data?
Data is added to the data model so
you can change the data as needed
Data is added to the data model and
cannot be changed in Excel
Data is added to a table in a
workbook
It makes it much easier to clean the
data by just changing it is Excel,
allowing you to bypass making
changes in the source data
Transcribed Image Text:What is the advantage of selecting the "Only Create Connection" option when importing data? Data is added to the data model so you can change the data as needed Data is added to the data model and cannot be changed in Excel Data is added to a table in a workbook It makes it much easier to clean the data by just changing it is Excel, allowing you to bypass making changes in the source data
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage