| Thread | Last Post | Replies |
|
| exporting access v1 data to access 2007 | 18 Jan 2008 14:37 GMT | 3 |
Is it poossible to export access data from a windows 3.1 program to access 2007?
 Signature Bruce M
|
| truncate zero in the starting when importing from text file | 18 Jan 2008 12:01 GMT | 5 |
I am importing data from text file, it has the field of telephone numbers, but access truncate all the zeros in the starting. I have set the field type as Text but still it is not working (although its work when I manually type data in that field but does not work while ...
|
| link a table using an .ADP access application | 18 Jan 2008 06:43 GMT | 1 |
I am using Access 2003 and have created an .adp, the back end is SQL Server, I would like the ability to link to a text table located on the network. I get the following error when I try to do this. "You cannot link to tables in file 'filename.txt' because your Access project ...
|
| Export to a xls-file | 18 Jan 2008 01:21 GMT | 1 |
I have a report in Access which I export to Excel by using the command "Export" in the Drop-Down-command menu in Access . In my report I have 5 fields ,let´s call them 1,2,3,4,5 from left to right in the report
|
| Export field contents to comma dilineated text file | 17 Jan 2008 22:51 GMT | 3 |
I need to export email addresses from a field in a table to a comma dilineated text file. What I've been doing is exporting the entire table to an Excel file, stripping out the other fields and then importing back to another Access table with only one field and then exporting it ...
|
| Export Data to Multiple XML Files | 17 Jan 2008 22:03 GMT | 1 |
I need to take each row of data from an Access table and export it to a separate xml file programatically (vba) as there are over 1500 rows. How do I do this?
|
| export database to a text file | 17 Jan 2008 19:02 GMT | 1 |
i want to export database to a text file so i can import it into another database program. i need to export it delimited because fixed width doesnt work with other database. the only way it works is export to a text file, delimited, tabs, but then everything is surrounded by ...
|
| Format for Exporting Access data | 17 Jan 2008 15:38 GMT | 1 |
I'm looking for the best format in which to export Access table data that will be emailed and imported into another Access database. (Using Access 2003) From what I've seen, perhaps Excel is the best choice but sometimes it seems the data formatting is lost in the process. I ...
|
| how do I download currency exchange rates | 17 Jan 2008 11:43 GMT | 1 |
I am looking for a way to automatically download currency exchange rates into my Access 2003 database. I have found an Excel macro that calls a web service that works great, but I cannot find a similar macro for Access. I would like to be able to grab the rates from the MSN ...
|
| Office 2007 Access import failure | 16 Jan 2008 18:28 GMT | 1 |
I am trying to import a 5 million delimited text file into Access 2007. I get the following: Error message :
|
| Importing Access query to Excel | 16 Jan 2008 18:00 GMT | 3 |
Using a query from access it is imported to excel file. For only one user it fails at this line DoCmd.TransferSpreadsheet 1, 8, "dbo." & QuerySending, SavedName, True, "InputRange"
|
| Import all related records | 16 Jan 2008 16:18 GMT | 6 |
I have a database with hundreds of customers (cusomer id) with many related tables. I have a blank database with the same structure. How can I import a specific customer id and all of that customer's
|
| access connections | 16 Jan 2008 14:40 GMT | 1 |
I want to setup access that will have 'screens' where users can enter car loan application information. I want this information to be saved in access once the save button has been hit. I want this data to connect to a .net WCF server and/or a service broker application that is ...
|
| Why do my linked tables not allow me to write to them? | 16 Jan 2008 10:08 GMT | 10 |
I use Microsoft Access to retrieve data from a Sybase database. I used link table functionality to do this. However, I am unable to write to the database. If I look at database window under tables and I refer to the column called "type" the value is "Table: Linked ODBC (Local)" ...
|
| ASCII Import Help | 16 Jan 2008 01:32 GMT | 3 |
I have some data that comes to me in an ASCII format. Below is a sample. The trouble is the data ontains double quotes used to identify Inches. But the ASCII format deliminats using double quote and comas. Is there a way to control the import so that I don't loose that data. What is ...
|