DataBase - How to link single excel spreadsheet to multiple access tables
Asked By tmdrake
18-Nov-09 03:30 PM
Is it possible to link a single spreadsheet to multiple tables. I have a
excel spreadsheet that contains with 22 columns of information. I would like
to link the spreadsheet to multiple (different tables), so that it will
update the tables everytime I update the spreadsheet.
If this is possible, instruction on how to will be greatly appreciated
--
tmdrake
Jeff Boyce replied to tmdrake
Not sure what you mean by "link spreadsheet to table"...
In Access, you can link to a spreadsheet ... and Access treats that link as
if it were a table.
Why would you want/need to link to the same spreadsheet multiple times?
What problem are you trying to solve with this approach?
More info, please...
Regards
Jeff Boyce
Microsoft Access MVP
--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can thank the FTC of the USA for making this disclaimer
possible/necessary.
2C_' = C3 = A9'? = DataBase Hi. I cannot find how to (programmatically) make a setting that treats 'ë', 'é', etc. the same as an 'e' for use in a recordset.FindFirst Thanks Discussions RstCurr.FindFirst (1) VbBinaryCompare (1) Recordset.FindFirst (1) DougSteele (1) SomeField (1) StrComp (1) Treats (1) Entrée (1) Use the StrComp function with a compare method of vbBinaryCompare (which is and the other way around). Hmm. You might have to use the Replace function multiple times: WHERE Replace(Replace(Replace([SomeField], é, e), ê, e), è, e) = "entree" - - Doug Steele, Microsoft 2C_' = C3 = A9'? = description: Hi. I cannot find how to (programmatically) make a setting that treats 'ë', 'é', etc. the same as an 'e' for use in a recordset.FindFirst Thanks
hip_measure] tblA [tblB].[hip_measure] is null Since I have the criteria "is null" about 10 times no records match my criteria. Is there a way to do this all in one them? Thanks. Access Queries Discussions Office (1) KarenAre (1) TblB (1) TblA (1) Windown (1) Treats (1) Times (1) Karen Are you saying that if ANY of the ten fields holds a Null If you place the "Is Null" criterion for each field on separate criterion rows, Access treats it as "OR" - - but if the "Is Null" is all on the same row, Access treats the selection criteria as AND's. Regards Jeff Boyce Microsoft Office / Access MVP Perhaps what
the report prints, you see a single record followed by multiple records below it multiple times. So the total report has several single records and below each are multiple records. I to help you as long as you are advertising here! I sure hope everyone here treats you the same way. . . IMO it is a shame that you even dare to ask
Discussions Office (1) Excel (1) Database (1) Morano (1) WhatI (1) Initials (1) Months (1) Treats (1) OK, I'll admit I'm confused, too. Are you saying that each "record was clear. . .lol. . . yes each record can take up three rows in my table. At times it may only take up two rows or even one. Do you think that it no way to suggest one tool over another. I can tell you, though, that Access treats each row in a table as a separate record. As far as I know, there