- Importing / Linking

Thread preview

Thread	Last Post	Replies

Link Excel table - found #num!	31 Mar 2006 19:46 GMT	1
Hi, I have data in excel e.g. 59 45 67
Exporting File with filename variable	31 Mar 2006 17:50 GMT	6
I have a query set up to output a flat file for an ftp upload. I need to save a local copy. I have a couple questions I haven't figured out yet... 1) The filename needs to be in this format ABCDE.#yyjjjhhmm The ABCDE is constant followed by the . and the # the rest is variable ...
How do I reformat names from "First Last" to "Last, First"	31 Mar 2006 17:36 GMT	1
and vice versa? Thanks!
Importing a text file with a negative number	31 Mar 2006 17:21 GMT	3
I have a text file that contains a column of numeric values. The negative values have the negative sign at the end of the number. Access file\|import can not handle this issue. Any suggestions?
ODBC db2 driver	30 Mar 2006 23:00 GMT	1
I need to obtain some data from a db2 database. Where can I get an ODBC driver for Access so I can attach to the db2 database? I've searched Microsoft website and found lots of info but can't seem to locate a downloadable driver.
Exporting data from Acess to Excel	30 Mar 2006 20:45 GMT	1
Once I get the results from the query I would like to export only X number of records to excel instead of all the records from the resulted query. How do I do that? For example my query resulted 70K+ records in this I just want to export first 30K+ records.
How to Link a file instead of embeding in Access Table	30 Mar 2006 07:08 GMT	3
I have seen searching and posting for help for the last 7+ days. I have not recieved any help so far. I hope this isn't a dumb question!!! I also tried the knowledge base, etc with on information on reconnecting links. Could I use that if I put a OLE
Access 97 Query to a tab delimited file	29 Mar 2006 20:22 GMT	3
I am trying to programatically export the results of a query to a tab delimited file. I have done this comma delimited by simply building a string then using the PRINT command to write the string to the file. How can I do something like this to ensure that the file is TAB ...
Exporting to a named worksheet and workbook	29 Mar 2006 16:02 GMT	3
I have used the DoCmd.OutputTo to export data from a query to a user defined .xls file. I now want to export data to a Sheet2 in a spreadsheet, which I know the name of.
Highlight new data added to Access database	29 Mar 2006 14:35 GMT	2
Updated New data imported into Access table needs to be a diffrent color to draw attention to it.
Import table with redundant data	29 Mar 2006 13:18 GMT	2
This is my first post but I have relied on many of you for answers to questions so Thanks much for all the help! I am trying to import a table 3 times a day from an email account. The problem I'm having is that the exported table (I had the option of getting a
Please Help, difficult situation on importing table	29 Mar 2006 10:48 GMT	3
Hi I got a really hairy situation. I want to import a particular table from an ERP database called Macrosoft (very little known relational database). The normal procedure would be to
Some problems with access	29 Mar 2006 06:02 GMT	2
Hello all! I have a database in access with some forms, reports, macroses, can I now make such thing: store all data from tables in mssql and use Access to work with them. I try to create Access projects and then or it import data from mssql and I
Access 2003 - Import Spreadsheet Wizard not working	29 Mar 2006 05:31 GMT	1
Hello, I'm using Access 2003 and can't get the Import Speadsheet Wizard to work. I go File -->> Get External File -->>Import --Pick the excel file I want and press Import but nothing happens, The Import Speadshhet Wiard does not show
import excel data to existing table	28 Mar 2006 23:34 GMT	1
New to access and need help. I have an existing table with customer info with about 50 fields. I routinely get an excel sheet which contains a customer name plus 11 of the fields.