|
Importing data from SQL Server indirectly
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 dump of the tables in an
Access db. The downside to that is that the relationships are lost by doing
it that ...
|
2 |
13.07.2006 16:30:18 |
|
|
exporting a hyperlink
Hi
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
to link to, but it is no longer a hyperlink.
I can see no way of formating the cell in Excel to be a hyperlink
Is there any way to resolve this?
TIA
John
...
|
2 |
13.07.2006 10:57:02 |
|
|
Output to Excel
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 the query??
Any help with this would be greatly appreciated.
JP...
|
2 |
13.07.2006 09:21:01 |
|
|
Export data to Outlook so as to add a Task in Outlook
I have a contacts database in Access. One field is a date field. When this
contains data, I want to export a name and a date and other data (Phone
number) to an Outlook task so that Outlook will alert me when I open Outlook
every morning.
If anyone has done this I appreciate some insight into the procedure.
Thanks...
|
1 |
13.07.2006 02:00:02 |
|
|
Link tables on between 2 db's on FTP site
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?...
|
6 |
13.07.2006 01:00:41 |
|
|
Import from from text file into access
I have text file that has data a bit like this:
username: john smith
password: happy
<text_start1>This is a sample<text_end1>
<text_start2>This is a sample<text_end2>
I want to :
a) import the first 2 fields into a access table (eg "john smith" is
imported into the 'username' field in the table
b) import the text "This is a sample" into a field in a table - but...
|
3 |
12.07.2006 23:31:01 |
|
|
importing designated fields from excel using key field
I have a simple table tblInvoices with the following fields:
[InvoiceID] (key field)
[EmployeeID]
[Payrate]
[Hours]
[TaxWithholding]
[NetPay]
My staff enters the EmployeeID, Payrate, and Hours via a form and then I
export a report with these fields plus InvoiceID to Excel. I send the
spreadsheet to our payroll company. They return us the same Excel spreadsheet
with the addition o...
|
4 |
12.07.2006 21:23:40 |
|
|
Importing only SOME fields based on Primary Key
Hi all,
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.
The mainframe will dump (for example's sake) approximately 10 fields
about each item (height, width, depth...
|
4 |
12.07.2006 20:06:58 |
|
|
Define Excel Column Names
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...
|
5 |
12.07.2006 14:14:01 |
|
|
Viewing Excel From Access
Using the following code I'm trying to open an Excel file called
TestFile.XLS, switch to a sheet called Status and then move to D1. The
file opens ok but does not switch to Status or go to D1. Instead it
just hangs until I click on the Access application or unload Excel,
then I get the message saying "Testing" but it still does not switch
sheets or location. I've tried several variations o...
|
1 |
11.07.2006 21:40:35 |
|
|
How to scan N&Address dir. entries into fields for database import
I want to scan a name and address directory using OCR to convert to editable
text in EXCEL or some other program. The scan and OCR work fine and are
brought into EXCEL in fileds. The problem is that each name and address info
is spread across several lines just as you would expect to see it. It is
then necessary to parse each desired field using a delimiter, however, there
is no delim...
|
1 |
11.07.2006 21:09:02 |
|
|
Linking Access to an Oracle database
I am trying to link an Oracle database to my Access tables. when I do so
Access is translating my Oracle table which is set to VARCHAR(412) to a memo
field. I actually only have about 150 characters in the field. I can't make
any changes to the Oracle database.
Can someone tell me how to get Access to truncate the field and set it to a
text field with a default value of 255 characters?
T...
|
1 |
11.07.2006 20:57:38 |
|
|
Open MS access with batch file in design mode
Hello there,
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.
z:
CD\MED_SERVICE\Manpower
ManPower.mdb /x
It still opens in the compile mode. please let me know what syntax to
use.
...
|
8 |
11.07.2006 16:02:13 |
|
|
Mapping multiple fields to one field
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
I want to map this into a table that looks like this
Facility Project info
LabA abc
LabA def
So basically I want to convert one long array of data into less columns with
multiple rows...
|
3 |
11.07.2006 15:15:02 |
|
|
Importing file with macro with primary key field added
I'm trying to import a file using a macro, but need to have a primary key
added to the file each time its imported. When importing manually, the
primary key field can be added, but I can't figure out if this can be done
using a macro. I thought by saving the import spec at the very end, once I
clicked on "add a primary key field" it might save it, but it doesn't.
Anyone have any clue?
...
|
1 |
11.07.2006 14:38:09 |
|
|
How do I modify fields in an access table linked to outlook
I am using Access 2003 and Outlook 2003: I have successfully linked Access
with my contacts in Outlok but the table does not include all the fields I
want. Is it possible to add or modify fields to this table?...
|
1 |
11.07.2006 12:01:01 |
|
|
Query Across Multiple ODBC Connections...
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 names should work. I
believe that VBA will be the way to go - I have limited experience with it
but I am learning. ...
|
4 |
10.07.2006 23:31:43 |
|
|
Access to InfoPath and BackAgain
Access to InfoPath and BackAgain
I have a table which is the datasource for my infopath form, users enter
dates which are submitted to the access database, i have a query which finds
the difference between the number of days between the dates. I want to run
the query from infopath or have the table run it upon any change. I then
recieve data back form access. i have it all automated exce...
|
2 |
10.07.2006 18:57:02 |
|
|
problems linking tables in access
I am trying to link tables in Access 2003. when I click on the Link Table
wizard, and pick ODBC - it goes back to the same screen I was on. My ODBC
drivers are working fine, and I can access current tables - I am just having
a problem linking new ones. Can anyone help?...
|
1 |
10.07.2006 18:08:02 |
|
|
Contact Info
Can you transfer the contents of an AOL address book to the Outlook contact
list?...
|
2 |
10.07.2006 17:59:15 |
|
|
Format trouble importing data into Access
Hi,
When I try importing data to Access using a client access driver from JDE,
the data returned is in binary format (unreadable).
The same data however when downloaded onto Excel using MS Query is in the
correct format. Could you please advise on any setting in MS Access to tweak
to get the right data format?
Thanks,
R
...
|
1 |
10.07.2006 16:52:01 |
|
|
Access can't link more than one Sybase table, but Excel can ???
Hi,
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 DB in Access, I
ALWAYS get an error: "Reserved error (-7748): there is no message for this
error" aft...
|
2 |
10.07.2006 13:22:41 |
|
|
Link Foxpro tables to Access
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 the various dBase
options (that dosen't seem likely)? Thanks in advance.
...
|
5 |
10.07.2006 13:05:02 |
|
|
Can two people share files between two IPODS?call it "ICONNECT"?
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
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this ...
|
2 |
09.07.2006 22:04:20 |
|
|
using bcc so that the recipient sees their name only
in outlook 98 when i sent several people a bcc each got what appeared to be
an individual message
how can i make theis feature work in outlook 2003?...
|
2 |
09.07.2006 22:03:35 |