| Thread | Last Post | Replies |
|
| Importing data from SQL Server indirectly | 13 Jul 2006 17:30 GMT | 1 |
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 hyperlink | 13 Jul 2006 11:57 GMT | 1 |
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 Excel | 13 Jul 2006 10:21 GMT | 1 |
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 site | 13 Jul 2006 02:00 GMT | 5 |
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 access | 13 Jul 2006 00:31 GMT | 2 |
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 field | 12 Jul 2006 22:23 GMT | 3 |
I have a simple table tblInvoices with the following fields: [InvoiceID] (key field) [EmployeeID] [Payrate]
|
| Importing only SOME fields based on Primary Key | 12 Jul 2006 21:06 GMT | 3 |
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 Names | 12 Jul 2006 15:14 GMT | 4 |
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 mode | 11 Jul 2006 17:02 GMT | 7 |
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 field | 11 Jul 2006 16:15 GMT | 2 |
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 GMT | 3 |
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 Info | 10 Jul 2006 18:59 GMT | 1 |
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 GMT | 1 |
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 Access | 10 Jul 2006 14:05 GMT | 4 |
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 GMT | 1 |
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
|