| Thread | Last Post | Replies |
|
| RunCommand acCmdExport Help | 09 Oct 2005 15:40 GMT | 3 |
A user wants to export an address book into any one of the choices that the export wizard offers. I have a query that runs that selects the fields for export. It has to be seamless from a forms window. I've tried the OutputTo command, but its limited to just a few file types. ...
|
| Importing some excel data to Access table | 08 Oct 2005 23:44 GMT | 4 |
I'm trying set up a new ACCESS database. (and I am a relative newbie) with a fair amount of EXCEL experience. I have some info on EXCEL worksheets, and would rather not retype the info. I am looking at using the first 5 columns of each EXCEL worksheet to be part of an ACCESS ...
|
| Strange error that effects nothing | 08 Oct 2005 22:09 GMT | 4 |
I've set up a database that is dependent on an import from Excel. I've tested the import and everything works fine. For some reason though I get a table added with the folowing name after the import is complete: COVERMEM$_ImportErrors
|
| keeping format on a text file | 08 Oct 2005 13:25 GMT | 4 |
I want to input data into access database but I need to keep some formatting like new sentence and paragraphs. do I do this as a memo or as something else. please help
|
| Import Text Data | 08 Oct 2005 08:31 GMT | 1 |
When I import a large text file with about 250,000 records, Access will drop the first couple characters in about 100 of the records. I've been able to verify that the missing characters are in the text file, but not in the Access table after the import. Any suggestions on how ...
|
| Importing dates formatted "yyyy, mm, dd". | 08 Oct 2005 02:58 GMT | 1 |
I'm experiencing problems when I try to import a date field. It's formatted: yyyy, mm, dd (eg. "2005, 10, 07"). Is there a way to import this as a date rather than text. And if I can't import as a date, how can I convert it to a date once I import as text?
|
| passing data between Access and Excel | 08 Oct 2005 02:12 GMT | 1 |
Is it possible to pass data from a an Access query to Excel for mathematical calculations and then pass the result back into Access to be displayed on a form? I would appreciate any type of help. Thanks a lot!
|
| what are the requirements to install office xp pro in a system? | 08 Oct 2005 01:59 GMT | 1 |
sir, This is siva from Andhra Pradesh.When I was installing Office XP Professinal " Error 2503" displyed .I couldn`t complete that installation. What are requirements to install office xp pro ?.
|
| Import text from Access to Excel as Formula | 07 Oct 2005 21:59 GMT | 1 |
I am importing data into Excel from Access and using that data in a pivot table. This sales data is either in US dollars or Canadian dollars, and I have a cell on my spreadsheet which contains a conversion value to convert USD to CAD as I want all totals in CAD. I
|
| Import Excel columns to Access datasheet | 07 Oct 2005 21:46 GMT | 16 |
I have an Excel spreadsheet that has 92 columns I use for recroding inspection data. The first 18 columns identify the record. The next 74 columns contain the inspection results. Some of the 92 columns have no data in them. The 74 results columns are made up of 37 pairs of data. ...
|
| How do I compare two tables, then add and delete based on one? | 07 Oct 2005 20:57 GMT | 3 |
Using Access 2000, how can I compare two tables for differences and then print our the changes? Trying to update physcian records for volunteer work I'm doing at a hospital. Thanks
|
| Import Timed | 07 Oct 2005 16:13 GMT | 6 |
I have written a VBA procedures which imports and processes data. I would like to run it daily at the fixed time, eg. 10:00 am. every day. I would like to run it without user iintervention. Is is possible to do so? Thanks
|
| Export Specifications | 07 Oct 2005 04:46 GMT | 2 |
I hope someone here can help. I have a file that has about 20 fields in it, and I need to combine about 4 fields into one field. But, they need to be formatted. Some needs to be subst other fields need to be padded with 0's at the end or at the beginning. Can this be accomplished ...
|
| Core database uses external data? | 07 Oct 2005 02:58 GMT | 5 |
I am not sure this the section to post my question. I have a database that is used for 3 different groups. The database is exactly the same for all 3 -- same tables, forms, queries, reports. The problem is when I make improvements, I have to do it to all 3 databases.
|
| MsAccess has a Create Table bug (won't allow VALUE as column name | 06 Oct 2005 23:22 GMT | 1 |
although you can use this column name in the "design" table program. ---------------- 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
|