Importing files

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

Where can I find some good info on how to import other excel files, access
data base ranges, and other file to import? Any good books on importing excel
files? I have a Power Programing for Excel with VBA but it doesn't show me
how to import data from another Excel file or Access data.
 
In Access you can export any table or query as an Excel file, so then you can
just open it.

In Excel, pull down File / Open, drop down the Files Of Type list and
examine the whole list by scrolling it.
 
I would like to import data from other Excel files and Access files on a
network drive in VBA, any ideas or code examples? Say I want C5, C7, A1, and
B24 cell values and I have user input a file name to pull these values from,
how could I code this?
 

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

How to easily migrate PST to Zoho account? 2
Browse button for access form 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Utility to flatten/import X12 834 file into Excel 3
Import 4 Different Excel Files from One Folder 0
Access Subscript out of range when importing into access 2010 from excel 0
When importing text field Excel chops off leading spaces 1
Import file to excel 2

Back
Top