Export query formula(s) to Excel
Hi:
I have some calculations in a query; one of them is:to_adj_GL_CEQ:
([adj'd_gl_ceq]+[adj'd_optex_ceq])*[Me_fx_rate]
Can you please tell me how can I export this formula into | | 13 | 22 | 10/30/2007 5:19:03 PM |
ODBC, Access 2003, and Windows Vista
Hi,
I have written an Access 2003 app that uses a system ODBC connection to
connect to a SQL Server Database. The app uses ADO to retrieve data from
linked tables.
This wo | | 0 | 18 | 10/30/2007 2:09:01 PM |
Number as date
Hi,
I am importing data from .xls to .mdb
One of my columns in .xls is a date field where the contents of the data
respect the format yyyymmdd but it specified as "number" forma | | 2 | 13 | 10/30/2007 1:10:22 PM |
How do I access an Approach db from Access?
| | 1 | 11 | 10/30/2007 1:07:33 PM |
why dont hotmail.com work?
i've tried to get on this but it would not let me use my hotmail.com e-mail
| | 2 | 23 | 10/30/2007 4:11:16 AM |
re: Getting too few parameters error message
Hi,
Getting the following error message when trying to important a table
produced by a union script (SQL) someone made for me on Friday.
[Microsoft][ODBC Microsoft Access Driver | | 1 | 13 | 10/29/2007 4:51:06 PM |
Import one 03 database into another 03 database
I would to import one 03 database into another 03 database and apend the data
into each existing table. I useing Access 2007
I tried the import function however it imported each table in | | 1 | 8 | 10/28/2007 8:53:00 PM |
Importing Excel Data
In my database I have two tables (Jobs & Files). I have a form (Jobs) with a
Subform (Files) where most of the data is entered. I have a one to many
relationship (Jobs(1), File(many)) using | | 6 | 18 | 10/28/2007 6:55:01 PM |
Covert Text to number
Hi - I import a text file which is saved as text and i need to convert that
text field in the table to a number field. Is it possible.?
| | 1 | 19 | 10/28/2007 11:50:01 AM |
Import Address Book from Live Hotmail to Outlook?
How can I move my address book from my Live Hotmail MSN account to Outlook so
they become the contact's list?
Thanks, Thomboy
| | 2 | 40 | 10/27/2007 9:05:00 PM |
Append Query Help Please
I have Table1 which has 50 records that I want to insert into Table2 which is
straight forward with an INSERT INTO Table1 (...) SELECT (...) FROM Table2.
However in on of the fields I need to | | 2 | 12 | 10/27/2007 8:20:06 PM |
Export to SQL based SQL system
Hi there!
I've never done this sort of thing before. In query design, to export to a
sql based erp system, I know to choose Another database. Can I assume that
from here I choose | | 1 | 11 | 10/27/2007 8:14:17 PM |
Find fields that will truncate importing from Excel to Access
I am exporting an Excel (2003) file into Access (2003). I want some of the
fields to be smaller than what the Excel data is, but I want to find the
records (either in Excel or Access) that | | 4 | 19 | 10/27/2007 1:30:00 AM |
How do I import an XML (or KML) file
I am trying to import a KML (XML) file into an Access 2007 table, but
everytime I try this process, I get a bunch of seperate tables. Does anyone
know how I can get just the following 'Field | | 0 | 16 | 10/26/2007 7:04:03 PM |
Importing a table into access from a web page
Hi there.
Using Excel, I can easily import a soccer league table from a web page into
a spreadsheet, which I can refresh automatically thereafter.
Is it possible to do the same in Access? | | 0 | 13 | 10/26/2007 5:35:00 PM |
HOW DO I SHARE INFO
| | 2 | 17 | 10/26/2007 3:01:00 PM |
Import SNMP date & generate network graphs
Does know of any methods to import data via SNMP to generate network graphs
for performance and trending. I currently have a script that outputs the date
into a CSV file on a daily basis but | | 1 | 14 | 10/26/2007 4:19:28 AM |
Export a Form and all Data to Word Document
Hi,
I have a land sales database that I input data into using a form. The form
happens to be in the format I use for appraisal reports that I create in
Word. I have tried to export the | | 0 | 17 | 10/25/2007 1:06:03 PM |
link data from access to excel
I linked a table from excel into access. I should be able to add, delete
records from access and have them link to excel but it does not let me add
new records. I can however add new records | | 3 | 13 | 10/24/2007 9:28:01 PM |
Write Text file from Access w/out Carriage Return
Need to write text file output from Access 2007 without Carriage Return.
Specs for file I need to create require only a line feed. Chr(10) Hex '0A'.
Access automatically creates Carriage | | 2 | 14 | 10/24/2007 7:20:00 PM |
Export data based on date
How would I export the contents of an entire database based upon date the
data was entered? I need to build a function that could build a new database
of the data with respect to the date fi | | 5 | 35 | 10/24/2007 3:51:02 PM |
max # of fields in import specs
Hey all,
I'm trying to edit my import specs and for some reason it will not let me
add any more fields(rows). it doesn't give me an error. it just doesn't
capture it when i save it. | | 6 | 16 | 10/24/2007 6:14:27 AM |
How do I scan business cards into MSO 07
What I want to do is scan a bunch of business cards into my computer and then
download them into a hand held device....
Any help will be appreciated..
Hefs
| | 0 | 13 | 10/23/2007 10:31:01 PM |
In a Word table you have a soft return. Do that in a memo field?
I have a large Word table that needs to come into Access. Some of the cells
contain a hard return to cause the line in the cell to break at a specific
word. How do I do that in Access? Onc | | 1 | 15 | 10/23/2007 9:29:28 PM |
Import Specification: viewing
Access 2003
Is the only way to see an Import Spec that I've created (other than querying
the system tables: MSysIMEXColumns, MSysIMEXSpec) is to pretend to import a
file, and then l | | 1 | 26 | 10/23/2007 7:23:18 PM |
I want to load data from excel to access using xml
I have data in excel (not in columnar format) that I need pushed to an access
table. By pushed I mean when the user completes his file in excel that the
data gets sent to access. This would | | 11 | 13 | 10/23/2007 7:17:36 PM |
Analyze In Excel - Vlookup
I ran a query and exported it to Excel to run a vlookup w/another Excel
spreadsheet. The vlookup failed because the formating of the exported data,
however, if I click in the cell of the ex | | 0 | 16 | 10/23/2007 6:51:02 PM |
Allow Access to send email
Hi, im using a macro to send an email to a single recipient with SendObject.
Microsoft Office Outlook is warning me that :
"A program is trying to automatically send e-mail on your behalf | | 2 | 11 | 10/23/2007 1:51:00 PM |
Import Errors Table not being created
I have a database that I have created to verify accounting codes for our VISA
Transactions, each month at the end of the cycle, I download an Excel
Spreadsheet with all transactions on it. | | 0 | 36 | 10/23/2007 1:29:02 PM |
how do you resolve error message (cyclic redundancy check)?
I am trying to analyze Access 2002-03 database. I have Vista 2007 Access.
When I try to open the db, I get an error message (cyclic redundancy check)
and it will not open the db. Another | | 0 | 29 | 10/22/2007 10:33:04 PM |
Importing Large Table - Reducing Time
Hello Again all
Following some advice from here an a bit of though from myself I have now
got a way of importing a text log file to access which allows me to retrieve
much informati | | 9 | 37 | 10/22/2007 6:20:03 PM |
#Deleted is being displayed in a linked table
I have linked to a mainframe DB2 table and when I try to open the table or
run a query against it, the only thing that display is "#Deleted" in every
cell. I know there is data in the table | | 0 | 9 | 10/22/2007 5:49:00 PM |
Import Excel Comments
Is it possible, when importing an excel file. To import cell comments?
| | 1 | 33 | 10/22/2007 2:49:22 PM |
Unknown Jet errors in Access database
We're using a Microsoft Access database with visual basic code for
automatically generating reports .
Since using Access 2003 we sometimes get next message:
"This property is not supported | | 2 | 59 | 10/22/2007 7:54:23 AM |
Error message when importing external data
I have a large XML file (database?) that I'm trying to import into Access
2007. This works without this problem when I use another computer with Access
XP (Access 2000?).
The proces | | 1 | 35 | 10/20/2007 3:18:00 PM |
Mail Merge sub records
I have a system where the user focuses on a record and then selects from
about 20 different letter templates options to print a letter. This all works
fine. I build a general query to pull o | | 1 | 26 | 10/20/2007 9:30:31 AM |
help needed
i have developed some functions in module using which i want to download CSV
files from a Stock exchange server. everything is fine but i am unable to
download CSV file, i get following msg | | 1 | 23 | 10/19/2007 8:53:56 PM |
Creating a copy of excel file
Hi there,
Is there a way to make a copy of an original excel worksheet from access
using vba and then open that copy.
example: original excel c:\localdb\original.xls
| | 3 | 10 | 10/19/2007 7:35:35 PM |
appointment entry - public calendar from access
at the moment i am exporting some dates into an appointment from access using
a command button which does this ---
Private Sub cmdAddAppt_Click()
On Error GoTo Add_Err
'Save r | | 1 | 14 | 10/19/2007 2:33:59 PM |
Help Please! :)
I am trying to export my numeric data from a table to an XML file format, and
the numbers export fine, but I want the 1000 separators to be included in the
export. I have the table display f | | 4 | 17 | 10/19/2007 4:44:20 AM |
How can I export to csv in access 2003?
I have read through the suggestion below but none seem to work. When I go to
export a database from Access 2003 or Access 2007, .csv is not an export
option. Text files is an option present | | 1 | 58 | 10/19/2007 12:30:15 AM |
How insert rows in Excel sheet from Access VBA code
Hello:
Please, I would appreciate you can show me the Access 2003 VBA code
necessary to insert 2 top rows in a previously existing Excel sheet and set
their cells to certain values.
| | 1 | 26 | 10/18/2007 8:23:40 PM |
Import data from Excel into an Access form
I have searched the net for the answer to this and tried different
applications but I've had no luck so far.
At work we have an Access Database that was designed by another
company. | | 3 | 21 | 10/18/2007 8:11:39 PM |
Importing from Word
I have a table in Word saved as a .doc file. I need to import the file into
Access. Can this be done, and if so, how?
Thanks in advance.
| | 4 | 20 | 10/18/2007 6:45:41 PM |
ACC 2003: errors exporting report to excel
Am exporting data from a report to excel. Some columns (a mix of text and
numbers) are exporting incorrectly even though all along had been working
fine. All I can find with reference to the | | 0 | 12 | 10/18/2007 1:51:04 PM |
access does not display odbc sources when selected
Hi when trying to link external data tables using Access, once I select ODBC
sources no "select Data source dialogue" is displayed. What is going on
here? And how can I get Access to allow | | 2 | 10 | 10/17/2007 6:09:05 PM |
Export specification not use?
Hello,
I created an export specification for exporting a query to txt file. In this
specification I use "." as Decimal Symbol, ";" as Fiels Delimiter and no Text
Qualifer.
Thou | | 1 | 10 | 10/17/2007 12:57:36 PM |
Access 2007 and email
Hi all,
I have created my new database. I am using email to import information from
my customers so I can keep better track of items I get in for
repairs/replacement.
The e | | 2 | 20 | 10/17/2007 12:47:00 PM |
Import text file
I know there has to be an easy answer for this but I just couldn't find it.
I need to automate the generation of a report. The data that feeds this
report is a tab delimited text file file | | 3 | 19 | 10/17/2007 3:59:00 AM |
Importing multiple queries Like "xxx*"
I'm working on a split DB that allows some users to create personal queries.
We've established a convention of naming user created queries as "P_somename"
Currently, when I update to a new FE | | 2 | 18 | 10/16/2007 5:37:52 PM |