| Thread | Last Post | Replies |
|
| Memo Field truncated when exporting as .txt - Text file | 12 Apr 2006 06:49 GMT | 1 |
When I export my query as a Text file, the memo field get truncated. Any suggestions as to how to prevent this? Using Access 2003 Thanks.
|
| Import Wizard Freezes on large CSV files | 12 Apr 2006 06:47 GMT | 3 |
I am trying to import some rather large CSV files into Access 97 (about 40-50mb). I open the Import Wizard, select the file, click ok, and then the program just sits. The Windows Task Manager claims that Access is busy, but I have let it sit for about an hour and still
|
| Import/export data from Excel into MS Project | 12 Apr 2006 06:23 GMT | 3 |
could someone have an idea, how to export data from MS project 2000 into excel , and how to import (load) data from excel into MS Project? Do I have to create absolutely a Access/ database for it ? I would appretiate your help.
|
| Controlling the sort on data Exported to Excel | 11 Apr 2006 19:56 GMT | 1 |
We are trying to control the sort order on a table that we are exporting from MS-Access to Excel for presentation and distribution. We had put primary key on the table, which was working for a while. Now it seems to sporadically fail. Short of creating select queries with an ...
|
| file types missing when importing tables from excel | 11 Apr 2006 18:20 GMT | 2 |
I have created a simple DB. When I try to import data by going to: File/Get external data/import... the only file types it shows are xml, odbc, access, and sharepoint. On my laptop I also have Access 2003 and it shows quite a few file types as
|
| importing more than one sheet | 11 Apr 2006 08:35 GMT | 2 |
I have an excel workbook with 4 sheets with similar data, I need to import this into a access table. Is this possible ?
|
| No installable ISAM | 11 Apr 2006 02:53 GMT | 3 |
I have been trying to solve a problem with ISAM errors. First I cannot linked anything in Office Small Business (2003) or Access 2003 which did not come with Office 03. I recently upgraded Access from 2002 to 2003. I do believe that everything was working after the upgrade. Then ...
|
| import contacts from a zip file on desktop | 11 Apr 2006 00:19 GMT | 1 |
I have exported a ms outlook zip file to my desktop and am trying to import it into business outlook 2003 to my contacts and it will not work. Could you please help me with this problem?
|
| Importing Hyphens | 10 Apr 2006 21:04 GMT | 1 |
When I import data that includes a hyphen (example MKT-CONSUMER) I now get a longer symbol (MKT—CONSUMER). Because of this, none of my queries will work unless I paste in the criteris so I get the longer — instead of -. See the difference? I've noticed in in Excel 2003 also.
|
| importing data from txt file with carriage return in one text fiel | 10 Apr 2006 19:00 GMT | 1 |
Hi, I have upgraded from office 2000 to 2003. Since the upgrade I can no longer import my textfile into Excel or Outlook, because any carriage return in a text field (text is marked with "", fields are separated with ;) will be recognized as end of line / paragraph mark, ...
|
| Bar scan into access | 10 Apr 2006 17:48 GMT | 1 |
I am not familiar with bar code scanning but was wondering if it is possible to scan with a bar code into access. What needs to done for this to work?? Picuturing that on the form when at that spot - take the barcode wand and it will scan it into that given field???
|
| import mm/dd/yyyy hh:mm:ss AM date format | 10 Apr 2006 14:13 GMT | 5 |
I receive a text file (.csv file) with dates in it in mm/dd/yyyy hh:mm:ss AM format (e.g. 1/3/2006 2:07:01 PM). I am trying to import this to a date/time column in my database using the TransferText action but I get an import error of Type Conversion Failure. I get this using ...
|
| Different tabs/different tables | 09 Apr 2006 23:57 GMT | 2 |
If I have 2 tabs on a form, how do I get each tab to have different information from different tables. Example: I'm creating a databade where the first tab is general client information and the second tab is important dates to remember for each client. How would you go about ...
|
| WHAT IS LINKING USED FOR IN ACCESS 2000. | 09 Apr 2006 23:25 GMT | 8 |
I created infor from excel and used export to bring it in Access. Now I want to be able to 'link' them so If I change something in one- it will automatically change it in the other program. IS THIS WHAT 'LINKING' IS USED FOR?
|
| Rejected Records Missing from Paste Errors Table | 09 Apr 2006 13:47 GMT | 1 |
When I copy from an Excel worksheet and Paste Append to an Access table errors occur. The problem is, not all of the rejected records are found in the Paste Errors table. Can anyone tell me where they went? Thanks
|