Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / July 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Importing data from SQL Server indirectly13 Jul 2006 17:30 GMT1
Ok, I'm wondering if there is a better way to do this.  I need to be able to
access data from a SQL Server database, but unfortunately we have no means of
directly connecting to that database, so the best we can do is get a data
dump of some kind from it.  The db admin gave me a ...
exporting a hyperlink13 Jul 2006 11:57 GMT1
I am trying to export a hyperlink field from an access 2000 database to
Excel.
In Access it is fine and the hyperlink works.
What I get after an export is the name followed by the text of the address
Output to Excel13 Jul 2006 10:21 GMT1
I am exporting information to Excel from Access to produce some fancy graphs.
There are always 3 fields that are produced in the queries, with another 3
as optional extras.  Is there are way of configuring Excel to adjust the
graphs accoring to the number of fields selected in ...
Link tables on between 2 db's on FTP site13 Jul 2006 02:00 GMT5
I have two Access databases on the same FTP site. I need to link 2 tables
from one db into the other database.  Can this be done? How?
Import from from text file into access13 Jul 2006 00:31 GMT2
I have text file that has data a bit like this:
username: john smith
password: happy
<text_start1>This is a sample<text_end1>
importing designated fields from excel using key field12 Jul 2006 22:23 GMT3
I have a simple table tblInvoices with the following fields:
[InvoiceID] (key field)
[EmployeeID]
[Payrate]
Importing only SOME fields based on Primary Key12 Jul 2006 21:06 GMT3
I'm going to be getting a weekly "dump" from our mainframe at work (in
the form of a pipe delimited file). This dump would include item
specific information about every product that we sell in our stores.
I have an access database that does a bunch of reporting on this data.
Define Excel Column Names12 Jul 2006 15:14 GMT4
I would like to export a query to Excel and define a header and column names.
I believe this is possible via VBA.
Thanks,
Bernie
Open MS access with batch file in design mode11 Jul 2006 17:02 GMT7
I have designed a database which opens in the compiled mode. Now when
you press the shift key it will open in design mode.
I want to open in design mode with a batch file. I have tried the
following code.
Mapping multiple fields to one field11 Jul 2006 16:15 GMT2
I have an output table generated by a web based form that looks like this
(example):
Facility     Project 1 info.  Project 2 info  etc....
LabA               abc                 def
Query Across Multiple ODBC Connections...11 Jul 2006 00:31 GMT3
Okay - so my company has setup each of our clients with their own Oracle db
instance.  If I was wanting to do some cross instance reporting, what would
be the best method?  Fortunately, each of client utilizes the same table
structure.  So one query calling the individual table ...
Contact Info10 Jul 2006 18:59 GMT1
Can you transfer the contents of an AOL address book to the Outlook contact
list?
Access can't link more than one Sybase table, but Excel can ???10 Jul 2006 14:22 GMT1
I'm trying to link tables in a Sybase DB to an Access DB. I have defined
successfully the Sybase DB as an ODBC source, and I can connect to it with
Excel. In Excel, I can import the tables content without any single problem.
However, when I try to link tables from the same Sybase ...
Link Foxpro tables to Access10 Jul 2006 14:05 GMT4
I just got around to installing Office 2003 and was trying to link some
Foxpro 6 tables to an Access database.  But when I bring up the link dialog
box, I don't see an option for Foxpro tables.  Is there some component I
need to install that I missed?  Or can I just use one of ...
Can two people share files between two IPODS?call it "ICONNECT"?09 Jul 2006 23:04 GMT1
I'm not sure if this has been thought of before or if "IPODS" already have
the capability of doing this. I also have another idea if your interested.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
Pages: 1 2 3 4 5 6 7 8 9 June, 2006
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.