import one spreadsheet from several from excel to access

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

hi all,
i'm trying to import specific spreadsheet from excel file but its
giving me the defaoult and not the once that i need
how can i decide via vba code on the spreadsheet i want to import?
 
Use TransferSpreadsheet for the import, and specify the sheet name in
the Range argument.

HTH,
Nikos
 
hi nikos,
from some reason when i'm putting the sheet's name in the range its
opening error,do you know maybe what is the problem and how can i fix
it?
i wrote "sheet1" or the name of this sheet but still it opens error msg

Nikos Yannacopoulos כתב:
 
Are you still out there? Sorry for the delay in coming back to you, I
was away on business.
Can you post your exact code please, as well as the error message that
you get?

Nikos
 
hi nikos,
thanks for your replay but i found a solution
my problem now is how can i do a vlookup/hlookup to a data coming as
matrix for ex.:

a b c d
A 1 2 3 1
B 2 3 4 3
C 3 4 5 5
D 4 5 6 7

how can i bring data from culomn b row C do you know maybe a way to
pull the inforamtion in the fastest way without vb loop
 
Not sure what you mean, but it sounds like you are still thinking in
Excel terms... vlookup/hlookup are Excel, with no Access equivalent. An
Access table represents a collection of similar entities (e.g. peolpe),
"columns" (Fields in Access terms) correspond to attributes of an entity
(e.g. last name, first name, date of birth, gender etc), each "row"
(Record in Access terms) represents a single entity (a person in this
example) and is identified by means of a unique value in a field that is
designated as a primary key (a Social Security Number would make a good
PK). So, to get the last name of a person with a given SSN, you would
use a query or a DLookup function, obviously in a defferent way than you
would do it in Excel. To begin with, your data in a table must be
meaningful as per the above example (one record for each one of similar
entities represented in a table, each with a unique identifier and a set
of values for different attributes). Is your data arranged like this? If
yes, what are you trying to achieve?

Nikos
 
hi nikos,
i'm dealing with an excel file,using an object from access
automation,it is pre-stage becaouse importing the file to the
access,usingf several of files and data doing some re-formating to the
excel file and this way importing it to the access.
i found some difficulties in finding data from a matrix table but found
some solution with the match function lets see how can i implement it
on the vba code,needs to save time instead of looping

do you know if there is a way to open msgbox box via vba code inside
excel(and not access)
 
You've lost me completely, I have no clue what you are doing.
Open a message box in Excel form VBA code executed in Access???
 
hi nikos,
dont be lost,you are correct,this is what i want to do.
the standard way is to open msgbox in access but becaouse the work is
being done in excel i would like to see the msgbox in the excel and not
in access so i will know there when the process ended

Nikos Yannacopoulos כתב:
 
hi nikos,
dont be lost,you are correct,this is what i want to do.
the standard way is to open msgbox in access but becaouse the work is
being done in excel i would like to see the msgbox in the excel and not
in access so i will know there when the process ended

Nikos Yannacopoulos כתב:
 
I'm afraid I don't know... not just how, not even sure if possible at all.

Nikos
 
Not sure what the beginning of this post it, but could you open the message
box in Access, Click OK, then have it Open into Excel? Or.... Not sure what
you are doing in Excel, but have a startup macro in Excel to show the
msgbox....
(Sry, trying to help without the original question...LOL)
 
hi,
it suppose to be simple
the execute of excel coming coming from access
doing the automtion the active aplication is excel and not access,so i
would like to get done message on the excel application and not in
access

MBSNewbie כתב:
 
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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access Subscript out of range when importing into access 2010 from excel 0
Importing Excel spreadsheet into Acces 1
Importing Excel Spreadsheet into Access 1
How to cause a spreadsheet (Excel) to run from an Access Macro 4
Import to many to many table 7
Import data from Access to Excel containing VB code 3
Microsoft Works to Microsoft Office 6

Back
Top