Creating a macro to import from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a macro to import data from a secific spreadsheet in
excel. This macro will be run by a command button on a form to import data
from Excel. I selected the Transferspreadsheet function and filled all the
required info. It's givig me an error "Failiure Creating File". Any advice on
creating macros will be appreciated.

Thanks in Advance
 
Tell us the details that are in your macro.... can't help until we see what
you have designed.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How to Create a Macro to Import External Data 0
importing from Excel 2003 to Access 2003 1
Importing via TransferSpreadsheet, receiving "type conversion fail 1
Importing excel table but user to select table in macro 4
Import Excel Workbook from Sharepoint 4
Manipulating Excel from Access 9
partial imported data fr excel is wrong by using macro to import 2

Back
Top