Exporting Data from MS Word to MS Access db
I am developing an MS Word 200 Add-In that requires collecting certain
sentences from MS Word document and storing it into MS Access 2000. I would
like to achieve this task without worrying | | 3 | 74 | 2/6/2008 3:26:01 PM |
Question About Importing Using VBA (DoCmd.TransferText)
Hello,
I want to write a routine to import a text file into a Access desktop
application. However, I don't download to the same file each month (I
date-stamp the filename data-YYMM | | 2 | 274 | 2/6/2008 2:50:38 AM |
Import XML file to Access 2007
I've got a bunch of data created by a navigation program (see sample below)
and I'd like to import it into Access. The aim is to eventually import it
into another program, after I've munged it | | 0 | 73 | 2/5/2008 10:55:52 PM |
WINDOW VISTA
I downloaded window vista advisor it gave me are package I should use the
home edition by the are some problems other programs are not going to run
like Norton Security,3G card and others. W | | 1 | 81 | 2/5/2008 9:49:01 PM |
can't import a dbf file
I'm trying to import two .dbf files into access 2000 for comparison. One will
import just fine, the other will not. It has message: External table is not
in the expected format. The bad fil | | 1 | 144 | 2/5/2008 8:22:00 PM |
Import Outlook 07 Information into Access 07
On my website I have a Form for clients to fill out. The info is sent to my
Outlook email. I want to link Outlook and Access so that Access will pull
that information into a table. All th | | 1 | 81 | 2/5/2008 7:56:01 PM |
import excel spreadsheet without empty rows (causing nulls)
Hi.
I am trying to import an excel file into access. The import goes fine or so I
thought. When I opened the table it had all my excel data plus over 9000 null
valued records.So inste | | 2 | 82 | 2/5/2008 6:52:00 PM |
Import XML-File using XSL-Transformation and creating numeric fields
Hi Access-Gurus,
I already googled for a couple of days for solutions to my problem,
but did not find any.
System: Windows XP, Access 2003.
Problem: I import an XML-file into | | 0 | 88 | 2/5/2008 6:48:51 PM |
Problem copying Access database
Hello. I'm using VB6 to move some files around one at a time. The file
system object method CopyFile works fine with the wildcard *.* as the source
but when I try to copy a single Access . | | 0 | 81 | 2/5/2008 10:50:00 AM |
Line number on customer detail
Hi, need help with following code, it work great. But after export to excel
the Nums column show only none sequence number from 1 to.100 which was
created when input new customer, and sort b | | 0 | 69 | 2/5/2008 9:34:01 AM |
Performance problem on import
I have created a database containing one master table, that has links to two
child tables.
I am attempting to do a mass import of data to this database using a C++
program and the
OD | | 3 | 74 | 2/5/2008 7:20:42 AM |
Appending into an existing Table
In Access 2003 I have a template worksheet which I import into an existing
access table using the Wizard. Normally, I highlight the file and check that
the first row are data labels then imp | | 1 | 88 | 2/5/2008 5:51:33 AM |
Unable to import since install of Office SP1
I am unable to import Excel, CSV, or Text files into Access from External
Data -> Import tabs since I have installed Office 2007 SP1. The error I get
during import is ?
|9 can?t | | 1 | 61 | 2/5/2008 12:26:44 AM |
too many transferText operations kills export functionality
We have an application that grabs data from a master table and then
exports text files containing just the data for each client - we
produce 50 text files every 30 minutes continuously.
| | 2 | 78 | 2/4/2008 11:05:47 PM |
Address Book Import into Outlook Express 6 Impossible
I've been spoiled with Apple. After a crash, all my address book contacts
were only available on my Earthlink webmail, which I exported into a CSV
file. However, importing that file, follo | | 0 | 90 | 2/4/2008 5:50:00 AM |
Export to fixed in 2007 - bug?
I never had an issue with these type of things in 2003, but repeatable
difficulty comes up in 2007. I'm exporting to fixed position flat file.
Initial query does some formatting like stripp | | 1 | 72 | 2/3/2008 11:27:51 PM |
DB2
Is there a way to export a table as a DB2 table?
| | 1 | 61 | 2/3/2008 11:26:50 PM |
unable to import from csv to memo field
When I import data from a csv flat file to access, the memo datatype columns
are truncated at 255. I found a lot of information about various operations
on the data that result in trucating | | 1 | 64 | 2/3/2008 11:26:04 PM |
Attached Excell Worksheets
We have a number of Excell worksheets that are used to bid and estimate work.
To date, I have been updating these using queries from Access. We are
evaluating Office 2007 and the major iss | | 1 | 66 | 2/3/2008 11:22:44 PM |
Need suggestion to set up development environment
Hi.
Not quite sure if it's the right group but I'll try.
I am redesigning an Access application for a client (from 03->07). The
application is linked to several SQL tables on a Micro | | 1 | 65 | 2/3/2008 11:13:35 AM |
Linked Sharepoint table permissions - Access 2003
I have 2 surveys on the same wss 2.0 site. I am linking these 2 surveys as
tables in Access 2003. I am able to access both linked tables as expected on
my primary machine. On another mach | | 1 | 92 | 2/2/2008 9:31:29 PM |
Modifying an import specification
I need to modify an existing text import specification by adding several
additional columns to the 15 that are currently in the spec. The import
wizard allows me to add the columns, choose | | 1 | 103 | 2/2/2008 5:06:39 PM |
acwizlib
Hi All... (anybody?),
I have an application written in Access 2000 to import text files calling
the import wizard using vba
ie. Application.Run "AcWZLIB.mx_Entry", 1, str_SourceF | | 5 | 71 | 2/2/2008 7:50:13 AM |
Export Many Unrelated Access (2000) Data Tables to Excel
I must export 130+ data tables to Excel...and those data tables are in an
(one single) Access database as separate, unrelated tables. The Access
database appears to be an Access 2000 creati | | 6 | 72 | 2/1/2008 9:40:47 PM |
Import specific columns from Excel
I need to import specific columns (A through G) from Excel; however, the
input files (excel) Does not have a constant number of columns. I only need
the first 8 columns. The Excel file has | | 1 | 114 | 2/1/2008 8:10:26 PM |
Adding Date to Exported File
I am using DoCmd.TransferSpreadsheet to move a file into Excel from Access.
This will be done daily so the date must be associated with the file name.
Each time I compile the module, I get a | | 4 | 71 | 2/1/2008 5:30:02 PM |
Export Query to Excel
I have two queries
query 1.
ProjID
TaskID
Money
Money2
ProjContact
querie 2.
TaskID
TaskName
Taskperson
I have one to many from query 1 | | 2 | 62 | 2/1/2008 3:07:03 PM |
Help with export to crystal
I am creating a database with weekly staff hours in a format of 40:00:00, I
figured out how to get access to accept these numbers but now I need to
transfer this data accross to a crystal re | | 2 | 62 | 2/1/2008 1:44:02 PM |
Trouble sending email using my internet service
--
Chrissy
| | 0 | 72 | 2/1/2008 5:02:00 AM |
using table stucture and importing data
I have been having alot of problems in importing data from an excel file into
a current table. I want to maintain the table structure, with field
descriptions, which is why using the "linke | | 1 | 68 | 1/31/2008 11:13:30 PM |
Multiple .CSV into One DB
I've got 200+ excel spreadsheets (.csv) and I need to move them into one
access db to run pivottables. Excel does not have enough rows.
Douglass J. Steele wrote in a prior message:
| | 12 | 72 | 1/31/2008 9:42:15 PM |
Blank Records appear after linking GAL from Access 2007
When I created a link to the Global Address List in Access 2007, the external
link was created, however when I open the linked table, the top row contains
the field names correctly but each | | 0 | 70 | 1/31/2008 5:22:03 PM |
Linking to Exchange 2003 GAL in Access 2007
Hi all,
having issues linking to the global address list on our Exchange 2003 server
from Access 2007. It appears to work, no errors, etc. But if I open the link,
there is no data i | | 1 | 79 | 1/31/2008 4:59:01 PM |
Importing a table
When importing a table, I expanded the options menu and noticed the radio
button "import/export specs". What does this mean?
| | 1 | 72 | 1/31/2008 3:23:09 PM |
French Version Import Spec Problem
I designed a database which imports a text file using an import spec. The
import spec works correctly on my PC which has a US version of Access. When
I copied the database to a PC in Franc | | 0 | 69 | 1/30/2008 9:12:00 PM |
insert data into different tables with one form in code?
I would like to put data from one form into 4 or 5 different tables by
opening and closing my reocord set and connection variable in different sub
statements. I'm trying to do this in a cont | | 2 | 80 | 1/30/2008 1:03:07 PM |
Linking Tables with Dates
Hi everyone,
I'm a relative n00b to access so please be gentle :)
I'm trying to link two tables together. In order to get aa unique field
from each table I need to concatenate | | 1 | 65 | 1/29/2008 11:20:00 PM |
Modify External XML Document
Using ACC2003 and exporting a query as a xml file. When I do this, the file
looks like this:
--------------------------------------------------------
| | 1 | 70 | 1/29/2008 3:10:21 PM |
Weird linked SQL Server table problem
I have a SQL Server view linked as a table in an Access 2003
database. One of the columns (FisYearName) in the view coming from
SQL Server is an nvarchar field although the data returned is a | | 0 | 70 | 1/29/2008 2:14:01 PM |
Importing dBASE 7 to MS Access 2003
Hi guys,
I'm trying to import a .dbf file (dBASE 7) to MS Access 2003. I'm getting a
"External table is not in the expected format". I'm wondering if there are
differences when tryi | | 0 | 85 | 1/29/2008 4:35:03 AM |
linking tables to external ones?
My database links to two tables in another access database and also to
two excel spreadsheets. At work these and the 'main' database are all in
the same folder with other stuff. However I of | | 2 | 68 | 1/27/2008 8:40:12 PM |
Compensating for Bad Data
Hello all,
I am using a piece of data collection software that has proven to be quite
glitchy. My major problem is that at random times it will return an
identical value twice sepa | | 7 | 79 | 1/27/2008 6:17:00 PM |
lose of bios
can any body tell me why evry time i turn my computer on i have to do the
time and date and year in bios
to startthe computer towork i have windows xp pro.,thanks houshang
| | 1 | 67 | 1/27/2008 3:55:14 PM |
Hey
Ros this is Ito tell Alazan that he is fuking ugly
| | 0 | 70 | 1/27/2008 4:21:35 AM |
Can't import to Contact Table in Contact Management Database Templ
I have been working on the Contact Management Database Template for hours and
have never successfully imported data into the Contact Table. This is after
making sure that all fields, columns | | 3 | 89 | 1/26/2008 10:13:19 PM |
Rename operating system file
Hi
Can anyone help me with the following problem:
I need to rename a textfile before this is imported into an Access table.
Any ideas?
Thx
Mike
| | 2 | 15 | 1/26/2008 4:32:00 PM |
creating a folder in word
I am in the process of created several forms that will merge data to Word
Templates that are legal documents. What I need to do is;
1) look in a defined folder in Word and determine i | | 0 | 12 | 1/26/2008 2:09:00 PM |
importing multiple lines of text into a field in table
Hi,
I'm new to both Access and VBA.
I have a text file with multiple fields to be imported to access.
But text file does not have fixed width.
Some fields have multiple lines of data. | | 1 | 16 | 1/26/2008 8:09:34 AM |
Work offline with Linked tables
Hello,
I have an Access application with linked tables. I am looking for a
way to run the application whithout being connected to the linked
database i.e. when I will run the Access applic | | 1 | 12 | 1/25/2008 9:20:03 PM |
Export Subform Filter to Excel
I have two tables that don't directly relate to eachother. I am using a
subform to filter in the records that I want to see. How can I export this
filtered list within the subform to an ex | | 3 | 13 | 1/25/2008 8:01:19 PM |