| Thread | Last Post | Replies |
|
| Acc2003: Errors exporting to Excel | 15 Nov 2006 06:49 GMT | 4 |
In Access 2003, I'm trying to export a report to Excel. When I try it programmatically using DoCmd.OutputTo, I get an error 3251, with a useless description ("Reserved error" or something along those lines). When I try it from the menu, I get no error but no file output either.
|
| File Name Argument | 15 Nov 2006 02:03 GMT | 2 |
I'm trying to import a text file, with the path chosen by the user. The file name argument is a function (TestIt2) that allows the user to browse for the file. DoCmd.TransferText acImportDelim, "", "tblData", TestIt2(), True, ""
|
| Importing Delimited text fil | 14 Nov 2006 20:43 GMT | 4 |
I am trying to import a series of delimited text files into an existing table. They are all delimited with semicolons, and most of the files went in correctly. However, I have two files that I am having problems with. When I try to import them, the import wizard recognizes ...
|
| Suddon Slow Manipulation of Excel From Access | 14 Nov 2006 19:39 GMT | 2 |
I have a Microsoft Access application that suddenly has started to run very slowly on some machines. In particular our (Dell) laptops seem very susceptable to this slowdown. Where before it might have taken 2 seconds to format one page suddenly
|
| How do I import data from access into my publisher program? | 14 Nov 2006 09:43 GMT | 1 |
I am using Access 2003 and Microsoft Publisher 2003. In Publisher, I created a directory. I want to import data in Access to Publisher and need it to be in column form. Preferably 5 down and two across on multiple pages. Is this possible?
|
| Export or Import to Excel and Format | 13 Nov 2006 21:54 GMT | 4 |
What would be the easiest way to either import from Excel (an Access report) or Export from Access a report to Excel? Once the report is either exported or imported into Excel. I need it to be formatted and set up with the correct tabs. Getting it into Excel with the
|
| editing after importing/linking | 13 Nov 2006 16:53 GMT | 2 |
i have linked an excel file and cannot edit one field column. error message reads. "control can't be edited it's bound to unknown field." is it possible to edit?
|
| Comparing multi paradox files | 12 Nov 2006 23:17 GMT | 1 |
Thanks in advance for any help you are able to give. I am new to coding VBA, but think that access is going to be the easiest way for me to compare the database files. My problem is, I have anywhere form 5 to 250 seperate paradox files and
|
| Query, Subform or Macro | 12 Nov 2006 17:00 GMT | 1 |
I have imported files from an excel spreedsheet into a new database in an attempt merge some fields. In previous years this data was provided to me with patient data being on "one" row with certain fields that have different dates being denoted with the test perfomed and the ...
|
| Importing from excel and/or word - new user | 12 Nov 2006 05:26 GMT | 7 |
I will be setting up a small db in access and would like to know: a) can I import data directly from Word (table format) or should I transfer info to Excel b) some fields have multiple entries per record - anything special to watch
|
| Sum query | 11 Nov 2006 12:42 GMT | 1 |
I have a table with phone numbers in them and the duration that they called I have a diffeerent table for each day. Each table has about 4000 records in it. There is about 200 phone number and they aopear in each table
|
| Numbers | 11 Nov 2006 12:04 GMT | 1 |
I'm trying to import a .csv file into access. The file contains phone numbers. How can I stop access from changing their format to scientific. I'm importing them as a "signle" I don't want them as text value as I
|
| ODBC link to Visual Foxpro leaves some tables not visible | 11 Nov 2006 03:40 GMT | 8 |
When I attempt to set up an ODBC link in Access 2000 to another application which uses Visual Foxpro, some of the tables are visible in the dialog box where I can select to which table I want to link, but others are not. Why can I not see all the tables?
|
| linking (?) fields between Excel docs | 10 Nov 2006 21:23 GMT | 1 |
didn't know exactly what to call this, so my apologies if this has been covered before. Here's what I want to do: 1) my company has Excel Sales Orders with many different fields --
|
| Auto run excel calculations in background - Help! | 10 Nov 2006 18:07 GMT | 4 |
I have set up an excel file (ExcelCalcs.xls) to pull data from Access via a 'Get External Data' query. The number or rows of data from Access changes based on user input, so I have the excel sheet (Calcs1) set to automatically replace all the data in the query with each refresh, ...
|