- Importing / Linking

Thread preview

Thread	Last Post	Replies

INSERT only new records	31 Dec 2003 22:06 GMT	4
Dear Reader, Currently i am able to import the data into the destinated table. As the source data file can grow in size. I only wants
ixf files	31 Dec 2003 19:11 GMT	4
Can you import an ixf type file to Access?
Pull specific Excel cells into field	31 Dec 2003 15:31 GMT	4
I have a database that needs to pull data from Excel. Specifically, my Access field should go directly to a cell in Excel and get that value. I'm thinking that I use some kind of VBA code to open my
ODBC: link from MS SQL Server to Access 2000, change of server	31 Dec 2003 12:45 GMT	3
I've inherited an Access database that is linked to an MS SQL Server database. Recently we got a new SQL Server and when installing it we renamed it. So, how do I change the servername in Access 2000? I've changed the servername in the ODBC-connection but it doesn't help. I ...
ODBC, Access Linked tables to Exchange data	31 Dec 2003 11:30 GMT	1
I have a Linked Table in Access which is linked to a Public Folder on my Exchange server. When I log in to the machine as a user who has access rights to the Exchange public folder, I can make changes to the records in that public folder from within Access and the changes are
data on ftp	31 Dec 2003 09:37 GMT	2
i am trying to link my database to an xls file on an ftp address. the massage i get is: "the wizard is unable to access information in the file 'ftp://homepages.ihug.co.nz/data/contacts.xls'.
Exporting Data to Word from Access is cutoff	31 Dec 2003 07:21 GMT	1
I have a user at my organization that utilizes a database created in Access 97 and she uses Access 2002 to open and view it. When she trys to copy data from text fields from tables, queries, or reports into a Word 2002 or Excel 2002
Batch convert access 97 to access 200 without typing filenames??	31 Dec 2003 04:39 GMT	1
PLEASE HELP!!! Upgraded from access 97 to access 2000 and now have a large number of 97 databases to convert to 2000. is there a means to batch convert the files without having to retype the file name for each database?
Import data	31 Dec 2003 04:36 GMT	1
I am trying to impot and access file from one computer using access to another computer using access. I used a USB 256mb memory stick. When I copy the file and try to open it I get an error saying its not in the right format.
Prevent Double Entry	31 Dec 2003 01:30 GMT	9
When we do importing, the data will always be add onto the existing records. The same data can appear more than 2 times, this causes my revenue figure to be inaccurate. Qns:
3011: could not find object 'TECCBW#TXT'	31 Dec 2003 00:50 GMT	3
The codes were working great in XP until an error message appeared as 3011: The Microsoft Jet database engine could not find the object 'fileName#txt'. Why is the period being replaced by the pound (#) sign? I do not understand
Link Unix	30 Dec 2003 23:37 GMT	1
How can I do to link Access 2000/Win 2000 to Unix server through ODBC? I can't find the right driver. Anybody an idea? Thx!
Export Access (97) from Windows 98 to XP	30 Dec 2003 22:21 GMT	2
I need help. I have Access (97) running on Windows 98. We need to move the complete datebase to XP running Access (97). This is a new computer. Thanks G-Mace
Truncating decimals on txt export	30 Dec 2003 20:23 GMT	2
How can I get more than 2 decimal places to be exported when exporting to a fixed length txt file? Thanks
import/export Nutshell to Access	30 Dec 2003 07:39 GMT	4
Customer address data is stored in Nutshell data base file. How can I get it imported into an Access file?