Export to .bat file
I need to export a list of names to a .bat file so that I can create folders.
I created the query to get the names out, but when I export using SendObject
there are text lines all around | | 0 | 30 | 11/11/2009 6:05:35 AM |
exporting items in excal database
Can you merge an excel database (using excel2007) with a catalog page on a
website. Is there a formula you can create to do this?
Thank you for any suggestions.
| | 0 | 18 | 11/11/2009 3:40:29 AM |
Multiple Spreadsheet Importing
Hiya Folks
So here's the deal:
I've been asked to create a database that can do some basic calculations (i.e.
standard production per hour per employee, etc). The problem is | | 0 | 37 | 11/10/2009 8:52:35 PM |
Exporting to Excel - adding information
Hi, I am trying to take a query (only 3 values and transfer them into an
excel worksheet. I want to open the workbook, write to the worksheet on the
next row available and put the 3 values | | 0 | 42 | 11/10/2009 11:22:12 AM |
Issue with Data Types when linking to SQL Server
When linking from Access to a SQL Server table that has float fields,
is it possible that Access can return all numbers with a decimal? E.g.
123 would return 123.0000000000
| | 0 | 33 | 11/10/2009 7:50:10 AM |
multiple choice menu
Hi, I have a field in Access that contains a multiple chioce menu. (the menu
where you have to put a flag for every options you need). I would like to
know how to import it into Access 200 | | 0 | 45 | 11/10/2009 7:50:09 AM |
Select Folder and Import from all Excel files in Folder
I am having a bit of a problem with an import. I am using a code from
Ken Snell that opens a navigation window to select a folder and then
all of the first worksheets in the folder are impo | | 0 | 31 | 11/10/2009 7:50:06 AM |
External Outlook subfolders
Does anyone know if you can import an Outlook folder including all subfolders
as one master table?
For example...
My INBOX + INBOX->FRIENDS (Sub folder) + INBOX->F | | 0 | 30 | 11/10/2009 7:50:03 AM |
importing a text file witnh european number formats
How do I import a text file that have number fields in European formats:
123.456,00
I can specify that a comma is the decimal separator using the Import/Export
specifi | | 0 | 31 | 11/10/2009 7:50:03 AM |
Importing data from Excel into Access
Can I import data from an Excel spreadsheet into an Access database and
identify what information is updated and what information is not updated?
| | 0 | 33 | 11/10/2009 7:50:02 AM |
Automatically (VBA) Make a DBF File from Excel.
...and then import that, via code.
I know how to make this work very well AFTER I make a DBF file manually from
Excel. Any code how to do that via code?
TIA - Bob
| | 0 | 29 | 11/10/2009 7:50:01 AM |
Ken Snell export code
I am trying to utilize two tables (customers) & (Invoices) to export filtered
data to 3 separate sheets. I have seen the code in Ken snell's site yet i am
not sure if this can be the s | | 0 | 37 | 11/10/2009 7:50:00 AM |
Migrating to New Computer
I am currently running Access 2000 on a Win XP/SP3 machine and will soon
migrate to Access 2007on a new Windows 7 machine. My database in is a folder
named Access on my D: drive. The new | | 0 | 26 | 11/10/2009 7:49:58 AM |
export teble to text keeping number format
Hi i export a table with 8 decimal places to text files and the export
reduces it to only 2 decimal digits. exporting with keeping the format is
limited due to the number of lines that can | | 0 | 23 | 11/10/2009 7:49:55 AM |
export from access to excel
I am running MS office in XP. My problem is when I export to excel some do
not show. i.e. up to and including row 1807 show (each with 21 columns)
={37947 cells} any data after this row wi | | 0 | 30 | 11/10/2009 7:49:54 AM |
Import data and update changed information
I have a DB2 database that is used to store information. I currently run
queries on the DB2 database using QMF and generate various reports in Excel.
I want to import those reports into | | 0 | 30 | 11/10/2009 7:49:53 AM |
Export to separate sheets
How does one export several query's to excell so each query has its own sheet
within the same workbook?
| | 0 | 29 | 11/10/2009 7:49:52 AM |
Cross-Tab Query Manipulations
I have a table (tblBranches) of Company Branch Offices listing BranchID
(primary key) and several other branch particulars.
I have a second table (tblEmployees) of Employees at the entire co | | 0 | 20 | 11/10/2009 7:49:52 AM |
Number Data Type Unavailable
I'm working with a complex database that was constructed by someone before
me. I'm fairly new to Access however I believe I know the error that is
happening when I import I just don't kno | | 0 | 27 | 11/10/2009 7:49:50 AM |
Import from Office 2003 Contacts into ACCESS 2003
I have Office 2003 Outlook which I use for Contacts data. I also have Office
97 Oulook Express which is my default email reader.
I want to import from the Office 2003 .pst containing | | 0 | 33 | 11/10/2009 7:49:50 AM |
Import Excel CSV file into Access 2007
I am using the following line of code to perform the referenced import:
DoCmd.TransferText acImportDelim, , "TempTable", strPath, False
Where TempTable is the table I wish to | | 0 | 30 | 11/10/2009 7:49:48 AM |
how do i import html tables to access
I am trying to use a hyperlink in access to go to the web and grab specific
tables so that i can append the info to a table i have 2400ish links to do
this with and would rather not do it | | 0 | 30 | 11/10/2009 7:49:48 AM |
Importing data from access to excel.
Whenever I import access data into excel, cell addresses I want to use in any
formulas have odd names. Instead of d3, etc, if the access document was
called 'work file', the cell would be | | 0 | 36 | 11/10/2009 7:49:47 AM |
Using obdc with an IBM iSeries
When trying to import a table from our IBM iSeries to Access 2007 using an
obdc driver I am getting the following error. OBDC --call failed.
[IBM][System i Access ODBC Driver][DB2 for i5/O | | 0 | 33 | 11/10/2009 7:49:47 AM |
exporting a table to SAS - date errors
Hello -
Does anyone know how to convert date/times into simple dates so that they
will be imported properly into SAS when I use a Proc Import. right now, they
import as a text | | 0 | 31 | 11/10/2009 7:49:45 AM |
Importing records in tables
I have a question, I am importing data into a table, if I use a macro to
create a table then 1,000 records = 1,00 records in table. If, though, I copy
and Edit paste special, 1,000 records | | 0 | 35 | 11/10/2009 7:49:44 AM |
OBDC Database Directory Error
Today, I attempted to open an OBDC data source to download new table
configuration. Windows 7 is defaulting to a new directory called Libraries
> Documents and when I select ODBC as t | | 0 | 30 | 11/10/2009 7:49:43 AM |
Convert format of date
My question is how do you change the format date to another format date.
for example: in my file all date like this:2009/09/14 but i want to convert to
2009-09-14 ofcourse i hav | | 0 | 22 | 11/10/2009 7:49:42 AM |
Importing one field with data
Could someone tell me how to insert one column, or field, from one database
into another? It has to carry over the data in the field.
Thank you :)
| | 0 | 33 | 11/10/2009 7:49:40 AM |
Why am I getting Type conversion failure when using transfer text
When using the transfer text code in Access to import a file to a table, it
is creating a seperate table import errors that only have the headers of my
data in it and they all say type con | | 0 | 31 | 11/10/2009 7:49:39 AM |
Linking Access 2007 DB and Excel
Hello-
I have a database created where I export the contents of a table into an
excel spreadsheet. Now that works just fine. My question is about linking
this spreadsheet to the | | 0 | 45 | 11/10/2009 7:49:37 AM |
multiple choice menu
I have
a field in Access that contains a multiple chioce menu. (the menu where you
have to put a flag for every options you need). I would like to know how to
import it into Access 2 | | 0 | 26 | 11/10/2009 7:49:34 AM |
Import from Excel - Subscript out of range
I am importing a spread sheet from Excel and keep getting a Subscript out of
range message. I've narrowed the problem down to an Excel row that holds a
date - if I don't import that row t | | 0 | 29 | 11/10/2009 7:49:33 AM |
How?:Link/export contacts from Access07 to Outlook07?
I have searched, without success, on how to either LINK or at least export my
Access07 contacts to Outlook07! Please help...
| | 0 | 28 | 11/10/2009 7:49:32 AM |
Import pictures
Hi,
I have a students database, and want to have an attachment field with the
student's picture.
What is the best (read easiest and fastest) to import those picture files
| | 0 | 32 | 11/10/2009 7:49:32 AM |
Export Pivotchart to Powerpoint
Is there a way to export a pivotchart (made in a query), to powerpoint in a
way that it can be refreshed when new data is added in acccess? Thanks!
| | 0 | 32 | 11/10/2009 7:49:30 AM |
Looking for help on up-dating
I am wondering if someone can tell me if there is a way to send a "blank
form" by e-mail from access to a user so thay can fill out a portion of the
form, it then get's routed to | | 0 | 24 | 11/10/2009 7:49:28 AM |
Lost .RTF
I have a Note program that is used by many people. Weekly we generate a
report which is sent to a .RTF file. What seems to be randomly, the last
part of a note is missing once it is in t | | 0 | 24 | 11/10/2009 7:49:27 AM |
Problem Importing Specific Worksheet From Workbook
Good morning everybody -
I am having a problem with a database that I am working on. I have a
file that is created in another database, and I need to import a
specific worksheet | | 0 | 31 | 11/10/2009 7:49:25 AM |
Linking between Access 2003 and Outlook 2003
Hi,
I apologise if this is already covered somewhere, I have looked but can't
seem to find an answer.
I am planning on creating an access database to maintain our corporate
| | 0 | 35 | 11/10/2009 7:49:24 AM |
Exporting pivot tables
How can I set a macro to export a pivot table from Access to Excel? I have
tried exporting the table (not pivot) and doing the pivot in Excel, but I
can't get the format the same as it is | | 0 | 37 | 11/10/2009 7:49:22 AM |
Back-Up Back-End Database
I have a back-end database for my data only.
Is there a way to back it up directly from my front-end db in Access 2007?
I see no commands that I would interpret as such.
I'm trying to a | | 0 | 22 | 11/10/2009 7:49:22 AM |
Access Externaldata Import
I am trying to import my email ms outlook 2007 into ms sccess 2007 via Externaldata. Everything works fine but the attachments dont come across. I have even defined a field for the attachment and it s | | 0 | 30 | 11/10/2009 7:49:21 AM |
joins in queries dropped when I import to another Access 2003 mdb
field names are also replaced with EXPR1, EXPR2 etc.
| | 0 | 29 | 11/10/2009 7:49:19 AM |
Link to ODBC source with different DSN names
I have tables linked via ODBC (IBM Client Access for iSeries aka AS/400) in
my database. I want to be able to have other people on my network run these
queries as well. We all have the sam | | 0 | 21 | 11/10/2009 7:49:18 AM |
Right-click to open TXT in Access Fails
We can import TXT files directly into Access 2002 using the Wizard, but when
trying to use the right-click, Open with MS Access from Windows Explorer, we
get this error:
Unrecognize | | 3 | 101 | 2/6/2008 7:43:53 PM |
Exporting text files
When I export data from Access to a delimited text file, double precision
numbers with 12 decimal places in the database are truncated to 2 decimal
places in the text file. I am using the ex | | 3 | 94 | 2/6/2008 7:42:19 PM |
Print Report to PDF with .pdf Name and Print Driver coded
I am assembling a number of smaller pdf files into a single file. In the
process I need to create some cover and separator sheets as reports and save
them as pdf's via the pdf995 utility. Ho | | 0 | 118 | 2/6/2008 7:37:22 PM |
import xml error
Im trying to make a form where the user will be able to pick an xml file and
import it to access. When I run the form, i get an error saying "Method
'ImportXML' of object'_Application' faile | | 0 | 108 | 2/6/2008 7:07:00 PM |
email essay as a dot.doc
Someone wants me to email my essay as a dot.doc, is this just a regular
Microsoft Attachment?
Thanks,
drjerrold at hotmail. c o m
| | 0 | 101 | 2/6/2008 7:06:01 PM |