| Thread | Last Post | Replies |
|
| Add field data to specific records in table | 18 Jun 2007 18:37 GMT | 2 |
I have a database that gets data from two sources. One source is direct data entry by me. The other is from Excel spreadsheets. On the spreadsheets, there are only four fields out of eighteen. (The others are either reptitious or not needed).
|
| Terminal Services | 18 Jun 2007 18:36 GMT | 1 |
Looking into Terminal services and need to understand how it works, what is required etc. I am completely new to this and need to know from basic upwards. If anyone can point me to pages/sites that has information that would be
|
| export outlook messages and attachments to access | 18 Jun 2007 18:36 GMT | 1 |
I wish to export outlook message content like date, to, from, subject, message, attachments, importance etc to access database for further tracking. I am unable to get the date and attachments. Other fields are possible through the wizard.
|
| Access 2007 importing data with extended character sets. | 18 Jun 2007 18:36 GMT | 5 |
I am trying to move over to Access large data sets. This data has extended ascii characters in them like ç, é etc... The characters are intact in the source data pull (txt file from a SQL 7 qry) but when I import into an Access 2007 table all of those characters get
|
| Error 53: File Not Found | 17 Jun 2007 16:05 GMT | 1 |
I am trying to export records to a txt file. I got the errot "Error 53: File Not Found" between these lines DoCmd.TransferText acExportDelim, , DocName, STRINGFOLDER & STRINGFILE & TEXTEXT, True, ""
|
| Transfertext question | 15 Jun 2007 22:10 GMT | 3 |
I have to export some tables for a data warehouse. At first they told me a CSV file would be ok but now they tell me they need the output with fixed length columns. And the lengths of the columns must not change from export to export. Is this going to be possible? There are text ...
|
| How do you print an import specification? | 15 Jun 2007 15:24 GMT | 2 |
I created and saved an import specification. I want to print this specification out as my "file layout" document. Can I print it or cut/paste into another document?
|
| Export to an already setup excel spreadsheet where columns<> | 14 Jun 2007 16:51 GMT | 9 |
I'm in a jam. I've been handed something to do that I haven't done before and have to have it finished tonight. I have been given an access db with three tables. I need data from those three tables and then I need to export the results to an excel spreadsheet.
|
| odbc--call failed | 14 Jun 2007 00:19 GMT | 1 |
i have an access application that uses linked tables. try to run a query using these linked tables. Sometimes get error ODBC-call failed. Works sporadically. Any ideas how i can fix so do not get this erro?? thank you so much
|
| Auto Remembering File Names | 13 Jun 2007 23:25 GMT | 2 |
Being new to Access, I'm trying to setup macros to import text files, one at a time, into access using a specified format, then immediately output them in Excel format. However, each text file has a unique name which I want to use in the name of the output file. Unfortunately, ...
|
| linking to excel table - problems with data type | 13 Jun 2007 05:31 GMT | 2 |
I'm trying to create a project that requires I link to data in excel. My problem is that when I link to the spreadsheet, some of the properties get set up as number instead of text. As a result, (at least I think this is why) my query on this spreadsheet doesn't return all the ...
|
| How to merge 2 tables with the same field names to form 1 querie | 12 Jun 2007 22:02 GMT | 1 |
I have exported two tables from Visual Cactus in DbaseIV form and I want to import them into Access so I can Querie the combined data. How can I do this in Access without first combining the data in Excel????
|
| import excel file into access and keep leading zeros for data 052 | 12 Jun 2007 20:55 GMT | 1 |
I am trying to import an excel spreadsheet into access. We have columns that have leading zeros (0521) when I import the file it drops my leading zeros. Is there a way to keep the zeros when I import the file? Thanks,
|
| Scanners, Barcode & Peripherals in general | 12 Jun 2007 16:49 GMT | 5 |
I guess this comes under the category of import - though not really.... I have gotten several separate inquiries about using a barcode reader to ease/speed data entry.....or a magnetic card swipe in a different scenario.... The database size is comfortably within Access's abilities ...
|
| Search key was not found in any record | 12 Jun 2007 11:30 GMT | 2 |
I'm using MS Access 2003. When I imported a text file in an existing database, it came up with an error msg "Search Key not found in any records". I tried to import the same text file in a new database, everything ok so I assume the text file itself has no problem. I also ...
|