Threads Replies Last Post 92 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   import text file - user is not dbo Hi, We have an application in Access which is linked to SQL Server. The code is VBA. We would like to import a text file to a table which is owned by dbo, but the user that is running the application is not a dbo. When we used doCmd.TransferTextMethod we succeeded to import data only to a table owned by the user, but didn't succeed in importing to a table owned by dbo. any code such as dbo... 7 06.09.2006 09:27:05 import excel sheet to access VBA I add data to a table of access by reading an excel sheet. I have to add a record to the table. Sub readexcelsheet() Dim db As Database Dim rsOrder As Recordset Dim strDirName As String Dim path As String Const NO_FILES_IN_DIR As Long = 9 Const INVALID_DIR As Long = 13 'On Error GoTo readexcelsheetPartition_err Set db = CurrentDb 'assign a path strDirName = "c:\Approval\200... 2 06.09.2006 04:18:29 imported data not pulling in query Hi. I backed up my data to another table, then proceeded to try and send data to an archive group; in which case it failed and I lost all the data in my table. So I imported the backed up data, and it imported fine. However, reports and queries are not pulling the data. Any ideas? I'm clueless on this one. Thanks all. ... 4 05.09.2006 19:22:02 There's no "IMPORT" "EXPORT" found when I pull the list fm File? I start to use Microsoft Outlook for my mails and I need to get addresses fm Outlook Express to Microsoft Outlook. I couldn't find "Import" or "Export" fm the File list to get the address book. How can I get my address book fm Outlook Express ? Pls help !... 2 05.09.2006 18:52:22 Importing Clarisworks Database Does anybody know how to get a Clarisworks 4.0 (for Windows) database into Access (XP), while maintaining some, most, or all of the formatting of the database? I would rather not start from scratch. Thanks.... 2 05.09.2006 17:06:46 export to Excel From Access Database Hi All, I have the following table that I would like to export to Excel: Town Name Bellmore John Freeport Paul Bellmore Ismail Merrick Bob Merrick Alan Freeport Mike Merrick Susan Bellmore Andria Bellmore Paula Freeport Sunita I have no... 7 05.09.2006 14:32:08 Invalid argument - importing dbf from shp-file Hi! I'm trying to import the attribute table of a shp-file - that is a dbf-file (from ArcGIS 9.0). It's worked many times before, but now it suddenly doesn't. I'm trying to figure out what's different about this shp or dbf. Often I get the message Access can't find the file and to check if the name is correct, even though the icon is there to click on. Then it usually helps to rename a... 3 05.09.2006 06:14:01 How do I convert a msworks data base file to an Excel data base? How can I convert a ms works data base file so that I can e-mail it to others who have nothing but ms office? They cannot open works files with office.... 2 05.09.2006 05:36:22 Schema.ini Hi, I've just discovered the schema.ini file. I'm wondering if it can help out with a problem we have. We have an application that we have on a remote system shifts out data as CSV files but does not provide any column headers. Can column headers for a headless file be provided in the schema.ini file ? TIA ..ooooooOoooooo. ... 2 04.09.2006 21:34:51 How to remove Tabs/Carriage returns from memo field on export to C I have a database that has a memo field. When exporting this database to a CSV file I want all the carriage returns and tabs removed from the field before exporting to the file. What is the best way to solve this. -- WCSC (Willies Computer Software Co) http://www.wcscnet.com... 5 04.09.2006 20:43:52 how do I publish databse to a web site I have a custom MS Access 200 database *.mdb with a custom front end *.mde. I would like to have the front end accessed thru a IE web browser and have the access database stored on the webserver. Of course I would want tight security requiring users to log into the web page that contains the *.mde interface. Also, do I need to be a rocket scientist to accomplish this feat? Thank yo... 2 04.09.2006 12:48:11 Auto Naming an exported file. I need to export/send(via email) a table from my data base. I can do this with no problem, but I need the file to be renamed with the name of the table and the date and time needs attached automaticallty to this file. Eg: CSV.txt needs to be sent as = CSV2.8.0609:00am.txt. Can this be done in a macro or visual basics.? If anyone can suggest a method, it would be very appreciated!... 2 04.09.2006 11:31:21 Can't Get to ODBC data sources in Access 2003 In Access 2003, when I try to do a File -> Get External Data -> Link Tables... and I select an ODBC data source from the Link dialog box, the Link dialog box disappears, but the Select Data Source ODBC dialog box never appears. If the MDB file I open already has ODBC links, the ODBC links are still there, and work fine - I just can't add any new ones. When I try the same thing ... 2 04.09.2006 06:41:01 Why Unspecified Error occur in Connection, of Data Analyzer? I am Trying the Data Analyzer to connect but on connection it will give the unspecified error why?... 1 02.09.2006 09:02:02 import longfilename.DBF Hi Guys, I have recently reinstalled access after a computer crash and I can no longer import .DBF files that I have been using for years. I have found that renaming them into the 8.3 format allows me to import them however, there is critical information in the long file name that I manipulate through VBA. Could anyone tell me if there is an addin or update that allows long filename sup... 10 02.09.2006 04:24:16 Removing carriage returns from Memo fields Hi, I need to export data from a memo field to a tab delimited text file. But I need to strip out the carriage returns in the memo field. Any suggestions on how to do this? I don't see the characters in the text file so it's I don't know how to tell if they are gone (I tried the Replace function). Thanks in Advance. ... 5 01.09.2006 19:57:30 Importing Data from Web link... Hi all, I was hoping one of you may be able to assist me, First off I am using MS Access2000: I need to import a web link into access but have had no luck so far is it possible? Thanks Dave ... 6 01.09.2006 18:51:58 Import hex file I have a user who will be receiving daily hex files in the future. The hex files will need to be imported into their Access 2000 database (the database could be converted to 2003 if it helps). Is there a way to write Visual Basic code to import this information? If so, could someone please point me in the right direction? I would like to avoid using additional programs, such as hex e... 2 01.09.2006 15:31:10 How can I get PowerPoint fields to pull data from MS Access? I am trying to create a series of MS PowerPoint 2003 slides that are identical except for the content of several text fields. I believe that 1) it is possible to populate these fields from the cells of a MS Access file so that each row of the table data in the Access database would populate each slide of the PowerPoint and 2) that these fields would then dynamically update on the Power... 3 01.09.2006 13:05:01 formatting exported data I need to export data from a single feild in a query to a text file separated only by a semicollin, with no spaces and no returns. thanks, maurie... 2 01.09.2006 13:00:27 repeated imports This question is largely about basic db design--it could probably go in New Users, but it does involve importing, so here goes: I've inherited a database in which the designer would import from Excel worksheets test score data from over a hundred schools with thousands of students. This would be a one shot deal in that he would create a single table with the student info and test results a... 4 01.09.2006 10:00:45 How can you automate a replica update? We have a base database on a local server, and we want to be able to updat replicas on server around the world. Where we want to update the base database, and have the replicas updated automaticly. Thanks Gil... 2 31.08.2006 18:52:20 line feed from Access to html Outlook email Hello, Does anyone know how I can insert a line feed in html text that I am writing to the body of an Outlook email message? Thanks, Mike ... 2 31.08.2006 17:18:48 Making an Access - SQL db solution portable I have an Access application which runs in a server enviroment where I have an SQL server that the Access connects to. The customer is so happy with my soultion and told another company about it, they would like something like that, so I need to make a copy of the setup to a cd to send to the other company - as a demo. They have no employees with enough IT knowledge to install a SQL Serv... 9 31.08.2006 15:53:02 Import errors w/dates I am trying to import a large (over 14K records) Excel worksheet into an Access database. The Excel worksheet was originally generated from an Oracle database. My problem is that when I import it, I get data conversion errors for two of the date fields. All the dates that I typed in myself in Excel are imported, but all the dates that were populated by the original Oracle query are no... 4 31.08.2006 15:26:32 92 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>