| Thread | Last Post | Replies |
|
| Q&A Import .asc missing data | 28 Apr 2006 18:43 GMT | 2 |
I have Q&A Database (DOS Version) that I need to get into Access. I have exported it from Q&A several times using different formats. Each format has its problems but I have most of the data in Access. However one field is truncated for some records but not others.
|
| error updating excel data from access | 28 Apr 2006 18:26 GMT | 2 |
I just applied the upgrade to Access 2003 and now the linked spreadsheet that I was updating via a query is no longer editable. I have tried creating a new link to no avail. Does anyone know what might be causing this? It was working in the earlier version of 2003.
|
| How Do I Export Integer Data And Maintain Leading Zeros? | 28 Apr 2006 16:11 GMT | 1 |
I've just created my 1st access database. I have several integer fields that need to maintain leading zeros when exported to a CSV text file. For example: I have created these fields as integers with a format of "00000000". When I look in the Access tables, I will see a value ...
|
| Link to MS Project File | 28 Apr 2006 10:09 GMT | 3 |
I am aware that you can save a MS Project file as an MS Access MDB but is it possible to link to a MS Project file from within MS Access. I am aware that MS Project can link to access but can it work the other way round?
|
| Linking Access 2002 to Oracle 9i | 28 Apr 2006 07:38 GMT | 1 |
I am using Microsoft's ODBC driver for Oracle. When I try to link to Oracle I get a listing of available objects, but an error message when I try to complete the link. The error message indicates "There are several tables with that name. Please specify owner in the format ...
|
| Can Access export to Excel as a read-only file? | 28 Apr 2006 06:59 GMT | 1 |
I need to export query results from a database using a Visual Basic module to an MS Excel spreadsheet, and have that spreadsheet 'read-only'. Is this possible? Thanks,
|
| access tables linked to excel files won't update. | 28 Apr 2006 06:49 GMT | 4 |
I have updated the data in an excel worksheet. I have used the linked table manager, as well as importing the data, but the new data does not show up in the access tables. HELP!!
|
| Importing Word form data to Access | 28 Apr 2006 06:46 GMT | 3 |
I'm trying to get data from a Word form (using form controls/bookmarks) but can't seem to get the code quite figured out. Now I'm getting error 3265... Please help. Thanks. Richard C.
|
| Problems with the Transfer Text Macro | 27 Apr 2006 13:18 GMT | 1 |
I've got a text file that I need to import into access. It imports fine with the wizard, but I've tried to set up the Transfer Text macro and I'm having problems. One one run of the macro it reduced the table to one feild with all of the data jumbled into it. Subsequent runs give ...
|
| Importing Variable column Spreadsheet to Access | 27 Apr 2006 13:00 GMT | 2 |
I have a spreadsheet that has the first 4 colums the same every month but the next 20 to 30 columns very in number. How do I upload this into access and attach the relevant code to each column then load to a table with 6 fields? I have a table listing all the column headings with ...
|
| Mixed exporting | 27 Apr 2006 05:45 GMT | 2 |
I have a vendor that needs a report exported from an accounting system to a tab-delimited text file. I will used Access via ODBC to do this, but the vendor requirements show that there are two sets of record types in the single exported file:
|
| where is data stored? | 27 Apr 2006 04:53 GMT | 3 |
can anyone tell me where the data for a particular database is stored in my computer? is it stored within the .mdb file such that if i opened that file on another computer with Access, all my data would be there also? or is it pulling the data from some other place hidden in my ...
|
| Local database with ODBC interface | 27 Apr 2006 03:06 GMT | 8 |
I am trying to create a local copy of an Oracle database to be used by an antiquated application. It communicates via an ODBC interface. I'm thinking that I can re-create the tables locally (through Access), and setup some sort of ODBC scheme. First off, is this feasible? ...
|
| How do I display values as text (1 = One) | 27 Apr 2006 01:46 GMT | 1 |
I am writting a program in Access that links to Word. To print checks I need to find a way to display the numeric values as text in words (i.e. 1 = One or 1032.23 = One thousand thirty two and 23 cents). I figure that this is either realy easy and I am completly missing it or ...
|
| Linking to ODBC File dsn | 26 Apr 2006 23:41 GMT | 3 |
When I try to change the file from Access ot ODBC in the Get External Data link dialog box the dialog box disappears and I can not select the file I want to. Has anyone had this problem or do any one of you have an idea where I can start looking?
|