| Thread | Last Post | Replies |
|
| EXPORTING AS ~ Delimited | 29 Nov 2005 07:40 GMT | 2 |
what is the easiest way to export the results of a query to a ~ delimited flat file? Thanks in advance.
|
| Appending Records to Table with an AutoNumber ID field | 29 Nov 2005 07:39 GMT | 2 |
I work with databases on the fly. I import part of the data, then import the rest in a separate, successive operations. I start with a text file. I import the data using the import data wizard, letting Access provide an Auto-Number ID. When I attempt to add additional records ...
|
| How do I import Excel files with different formats? | 28 Nov 2005 22:21 GMT | 3 |
I have a project that someone wants me to do. They have about 8 different vendors send them Excel spreadsheets that contain their current sales reps contact info. These sheets are EXTREMELY different (i.e. some list their rep's info in a row, some separating city, state, zip, ...
|
| Date field appear as long integer | 28 Nov 2005 18:03 GMT | 2 |
I am working on a access table which is link with some external software (3rd party software). Everything works fine but the date/time field is appearing as a long integer value i.e. 1132675652 or 1132674975 etc. I want to convert this numerical
|
| import specification for access 2003 | 28 Nov 2005 18:01 GMT | 1 |
I cannot seem to find where to create an import specification for access 2003. I know there used to be an advanced button on the import wizard, but it's gone with 2003. Can anyone help me figure this out?
|
| Change Link Table to Local Table With VBA | 28 Nov 2005 08:59 GMT | 2 |
I have a linked table with SQL Server. I can click Edit, Copy, Paste and get a choice of whether to create a linked or local table. Is there a way to accomplish the same thing through VBA ? I found the copy command: DoCmd.CopyObject , "Customers_bk", acTable, "Customers"
|
| work in excel, keep data in access | 28 Nov 2005 06:40 GMT | 1 |
I have an excel file, for example job country code 111 albany 11 111 albany 12
|
| Import - Existing Table isn't showing as an option | 27 Nov 2005 22:27 GMT | 1 |
I have created a donor tracking table for a non-profit. I created the table by importing an excel spreadsheet into Access. If i try to import any new records from excel, the option to import into an existing table isn't available.
|
| Automate "Get External Data" over HTTP with a BasicAuth protected ressource | 27 Nov 2005 12:26 GMT | 3 |
Using the "Get External Data" import dialog of Access 2003 I can import an XML file from a remote URL. If a that URL needs credentials (BasicAuth), I'll be prompted for username and password and the import works fine. Now, if I try to automate that process using
|
| Parsing / ' " characters | 26 Nov 2005 19:01 GMT | 7 |
Have a lnked text file I need to extract data from - only one character field in file, but some of the records have // ' " characters, so when I try to
|
| fill a few cells in an excel spreadsheet from a form | 26 Nov 2005 07:50 GMT | 3 |
What is the easiest way to populate a few cells in an excel spread sheet from an Access form via Vbasic?
|
| Excel to Access | 26 Nov 2005 07:39 GMT | 3 |
I have a corporate employee calendar in excel that I must maintain. I would like to link it to my online calendar for "employee request for time off" that feeds to/from an access db.Is this possible and does it require coding?
|
| Import data specifications | 25 Nov 2005 19:30 GMT | 2 |
thow do I export an specification used to import TXT files to other access database?
|
| im looking to add a backup feature to my switchboard in MS Access | 25 Nov 2005 14:17 GMT | 3 |
im looking to add the backup feature in the file menu to my switchboard as a button or a macro
|
| Mailmerge from Access does not filter first name in database | 24 Nov 2005 20:14 GMT | 1 |
I have Access 2000 database and we have upgraded our computer system to XP and Office 2003 - now when I mailmerge my data on these machines it always selects the first individual in the database no matter what the filter parameters - the remaining are correct. Thanks. Ginny
|