Import Data

  • Thread starter Thread starter Shane Smith
  • Start date Start date
S

Shane Smith

When I'm trying to import from an external data source via (Data--> Import
External Data--> Import Data.) I have to navigate for the data sources.
I was wondering if there was a way to make excel default to a directory
other than the "My Data Sources" directory? Can this be edited in the
registry?

Any help is greatly appreciated!

Thank You,
Shane Smith
 
I'm don't know the answer to your question, but if you need to extract
data from databases into excel on regular bases, I found this software
named Sql-batch suite, which let you create new menu in excel with
predefined sql queries that are run from excel directly into your
spreadsheet. you can download it from http://urisoft.netfirms.com/
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 default folder for Queries 2
need user input command in macro 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
relative path in OLEDB string 3
Linking to Access data without destroying formulas 16
Importing xml file to excel 2
filter on excel table with msquery and replaced header 1
Stopping excel from converting numbers into dates on import 10

Back
Top