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  >>   How do I insert a whole Access table in Oracle ? Hi I have an Access app that reads and processes data from a Sybase DB, and stores the processed data in one table in Access. That table has 62 attributes. I'd like now to "copy" the content of that table into an Oracle DB. I've got access to DB and table, I can manually insert one row in the Orcale table with values for the first 2 attributes of the table, so everything would be read... 1 31.08.2006 15:22:02 importing text files into access 2003 Hi, i'm now facing a problem of importing data from txt files into access 2003. here's the sample of how the text file looks like: DATE :11/08/06 BUYER : M00000 S.A.S ORDER NO. :(SAMS-SP-000/00) LOCA TERMS/CURRENCY : 15th of next month / S$ or US$ or Yen PAYMENT : 15th of next month PACKING : CARTON CASE POR... 4 31.08.2006 08:50:01 "Package" instead of "Adobe Acrobat Document" for Linked PDF in ta I am using OLE Object in the table to link the PDF file which is stored in an sub-directory under the main directory of the database on my local computer. The table used to show "Adobe Acrobat Document" for the linked PDF file so that the file can be double clicked to open. But after a certain time (I didn't know what I changed to my computer at that time), the property of newly-linked P... 3 31.08.2006 01:42:01 many excel sheets in one access table I have many excel files containing one sheet in each and i want to append all these files in a single table in access. could it possible. Thanks... 4 30.08.2006 23:05:51 Splitting multiple values of a column in to new rows while importing data I am trying to import an excel spreadsheet in to MS Access. One of the columns I am trying to import containes multiple values, separated by |~*~|. For each value in this column, I need to create a new row during import, replicating all of the values from the other columns in the spreadsheet. Is there a way to do this. Thanks, Sreekanth ... 10 30.08.2006 19:31:02 Attaching a CSV file to an Outlook Express Email from Access Hi - I've been transmitting orders to a supplier by using SendObject with a string of text that contains the order info. Now, the supplier would like an attached comma-delimited file instead. But SendObject doesn't seem to allow me to send a table comma delimited. I can use TransferText to make an ASCII comma-delimited text file, but then I would have to attach it manually to the emai... 7 30.08.2006 15:45:20 Access 2003 add a carriage return, line feed inside a memo field7 I've imported an EXCEL spreadsheet into an Access 2003 database. As a result, squares showed inside the memo field wherever there had been carriage return / line feeds in the EXCEL field. I can replace the squares with semi colons and a blank space, but would prefer to replace the squares with a line feed / carriage return in Access memo so that the memo field on the report would print... 2 30.08.2006 13:06:02 Databasedump Is it posible to make a dump of the hole database to a textfile - like MySQLdump.... 1 30.08.2006 11:12:02 Access 2002 (Office XP) text import wizard broken/not found Upon several attempts to import a text file, the following message is received: Microsoft Access can find the wizard....wizard not installed...incorrect setting in the Windows Registry...wizard disabled. I have checked the list of disabled features, none exist. I have followed the recommendations of article 290068, highlighting a similar problem, and found the registry setting to alread... 12 30.08.2006 05:46:01 Export a table daily I have created a database where I have multiple table objects. I have a form that adds data to my main table called TEST. I created a Crystal Report that reads data from this TEST table. I want to be able to save, delete, and update this table on a daily basis. For example, I would like to save a copy of the data from TEST for today, and name it 060825de. Then, I would like to save t... 5 30.08.2006 04:43:49 How does Access decide the data type when import tablefrom Excel How does Access decide the data type for each field when importing a table from Excel?... 3 29.08.2006 23:40:23 Macro to Import a DBF File I've got an app that has a table created by Importing a FoxPro .dbf file. Currently, I only need to occasionally "refresh" it by re-importing the same file (the app that feeds data is in VizFoxPro and will only write to these type files). However, I now need to re-import it pretty often. Fortunately....it is stored on only one place and will always have the same name. Is it possbile t... 3 29.08.2006 22:17:44 RELATIONSHIPS WITH IMPORTED DATA I have created a parent;child;grandchild database and have imported the data using paste append from other Access data bases. How do I get the relationship between the data to work. I have tried typing in the Parent Id No but this does not work.... 1 29.08.2006 20:37:01 Access 2003 Import Wizard from code? Is there a way to trigger the import spreadsheet wizard in access 2003 with code? Thanks. ... 2 29.08.2006 19:45:44 Can Access link to Outlook calendars? I want my Access database to automatically update deadlines that it reads from an Outlook calendar. I don't see how this is possible. Any help?... 2 29.08.2006 19:30:49 linking databases Hi, I'd like to know if, after you've linked two tables from two different Access databases, you can update records in both tables by simply upadating the records in one of them. So if I change "dtmYear" from say 1997 to 1998 in one table, then "dtmYear"in the second table would also be changed from 1997 to 1998. Is there way a to do this? ... 17 29.08.2006 19:13:02 extracting data from linked db2 table using access make table quer Hi, I am trying to retreive data from db2 linked tables using a make table query. I can select but when I change the query to a make table query, it give me the error "invalid argument". Has anyone had this problem and/or know how to fix. Thanks GinnyP... 1 29.08.2006 18:31:01 Creating a "create table" script for an Oracle DB Hi I need to give to an Oracle DBA an SQl script to create in his DB a table with the same structure as one of my Access DB table, the content of which I will insert afterwards in a daily processing in that table in the Oracle DB. I can't find find any way in Access to "export" the table structure in the form of a standard SQL script that can be used by the Oracle guy. I'm surprised,... 2 29.08.2006 17:21:54 keeping number formats when exporting from Access to Excel Data exported from Access to Excel has some phone numbers formatted with the (-) character and some without. Also some postal codes retain the space and some do not. How can I retain this formatting?... 4 29.08.2006 14:05:02 Export Entry to Excel I have a table which contains all the information I require to make specific invoices. Is there a way to programatically export the entry once it is complete to Excel? The invoice form is set up in Excel. Thank you for your help. Jennifer... 2 28.08.2006 23:35:42 Access changes in mailing list not appearing in other formats I made some additions to a an Access database I developed and the recent changes are not appearing in the other formats. ... 1 28.08.2006 18:38:01 need code can anybody send me the vba code to winzip the folder? ... 1 28.08.2006 18:02:09 Excell Update when linked to access I have 4 excell files with the same format and all linked to a single access db. The problem I have is that the excell files are not updating automatically when being linked. (the 4 files all point to other tracking systems). Is there a way to update the excel sheets from access after the link occurs? ... 5 28.08.2006 16:16:01 Null value in autonumber field After importing an Excel 2003 worksheet into Access 2003 table I get a "Null value in an autonumber field" error. I do not have a column in the worksheet that would match up with the autonumber table field. But I don't want to have to create a number for each row in Excel that I import. What am I doing wrong? Thanks, Jim... 1 28.08.2006 16:01:02 Link table problem When I try to link a table in Access 2002 to a database with 30000 tables it only shows me one table. For those in the office with Access 2003 it works fine, albeit slow, and shows all the tables. Is this a bug in 2002 and how do I fix it? -- burt_king@yahoo.com... 5 28.08.2006 15:38:02 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  >>