|
Removing quotes from a csv file after DoCmd.TransferText
Hello. I have seen this topic covered here but it was two years ago. I
built a database in Access 2003. When the user clicks a command button, the
click event procedure runs/exports a table data to a csv via the acdelim
method. DoCmd.TransferText, acDelim, etc etc
When the file comes out onto my hard drive, I open it with Notepad. I see
quotes surrounding fields that have text in them....
|
8 |
13.06.2006 05:57:14 |
|
|
Importing and Normalizing
I recieve a number of unrelated tables from the internet which are usually
updated monthly or quarterly, and which i copy and paste into excel. These
tables typically have the date as row headings and various different 'items'
as column headings (ie. workplace absences per month in Canada, Ontario,
etc).
I also have an Access database with a main data table in this form: ID
(autonu...
|
6 |
13.06.2006 13:01:02 |
|
|
Importing Excel spreadsheets
I have a number of Excel workbooks that all contain at least 4 worksheets.
The information in each worksheet is the same layout just different values
of data from different companies. The worksheet looks something like this
.....................Type1................Type2.....................Type3...................Type4
Category1.....(Value)............(Value)....................(Value)........
|
5 |
13.06.2006 08:33:35 |
|
|
export wizard blank (no sample data)
I've done this many times and suddenly I cannot export a query in datasheet
view to a text file. I have the latest jet updates. The original database was
2000 format. The wizard is not working even after converting the database to
2003 format. When I run the query and open the export wizard, the window is
blank. Security is set to low. I can select all and paste into an Excel sheet
as a ...
|
5 |
12.06.2006 22:49:59 |
|
|
How can I bring in some file names from a folder to a table?
Each day we receive a file from another company. We store the file as a .CSV
in a folder. Our users want a form that will list the available files so
they can select which file they want to work with.
Is there a way I can import/link to those file names so I can display them
on a form? Like when they open the form the names appear in a list box?
I've been searching through help for ...
|
2 |
12.06.2006 20:48:29 |
|
|
DoCmd.TransferText doesn't work unless you run a file manually
I am running the DoCmd.TransferText command to import a number of text files
into a database. If I don't run a file manually first I get an error from
Access on the first file saying the file cannot be found. If I run one file
manually using same file spec to start and then execute the code the
procedure works fine.
Here is the code:
-------------------------------------------------...
|
2 |
12.06.2006 20:39:32 |
|
|
Is there a way to batch import Excel files into Access?
I am trying to find a way to move multiple Excel files into access at one
time. I do not know much VB yet...
|
2 |
12.06.2006 20:35:34 |
|
|
Emailing a picture
im using docmd.sendobject to send an email to my customers.
Is there anyway to add a picture to the main email body text? i have a
graphic which is a header and i want to insert it before the text.
heres my code so far:
Private Sub cmdSendInstantEmailAdvert_Click()
On Error GoTo Err_cmdSendInstantEmailAdvert_Click
Dim Company10 As String
Company10 = DLookup("[Company]", "...
|
2 |
12.06.2006 20:34:24 |
|
|
Export Specs no longer working properly
About two years ago, I wrote an export specification and since then it has
always worked correctly. It has been run weekly for two straight years
without a problem. today when I tried to run it, the data did not format
properly on the export. The data is exporting to a text file and it should be
fixed width, but today it is exporting as delimited with spaces as the
delimiter. No changes...
|
2 |
12.06.2006 19:41:02 |
|
|
Why are some tables read-only in an ADP?
I've created a couple of Access Data Project files - practicing upgrading my
access databases into SQL server databases.
The problem I have with these ADP files is that I can only write to some
tables - and there doesn't seem to be any rhyme or reason why.
I've made sure that the permissions are all checked for my integrated
windows user, but it doesn't seem to make any difference, bec...
|
2 |
12.06.2006 02:00:54 |
|
|
Remove Queries
How do I create a modified copy of an Access (2000) database file and remove
the Queries, Forms and Reports?...
|
2 |
12.06.2006 01:49:50 |
|
|
Question for Mr. Leban
I have used your A2KAutosizeOLEVer6 to create a database that generates
reports with pictures and the pictures are autosized. I was wondering if it
is possible to integrate this function with the functions in your
A2KLoadSaveJpegVer9 so I could reduce the size of my database since I will
have hundreds of pictures in there.
Thank you for your help....
|
4 |
11.06.2006 21:42:59 |
|
|
Excel import error - Object or class does not support set of event
Attempts to import any Excel file into Access 2007 result in this error: "The
Expression On Open you entered as the event property setting produced the
following error: Object or class does not support set of events". What do
I need to change so I can import an Excel file?...
|
1 |
11.06.2006 03:53:01 |
|
|
DAP and webhosting company.
Hey guys.. I have several daps that work on my machine.. once i post
the db and the daps to the web though it won't work. So I enabled
UseRemoteProvider to true, and tried changing the source (through
notepad) and it now gives me internet server error : object/module not
found.
Is it not possible to host Daps on external web hosting companies? All
the white papers I've read point to creati...
|
4 |
11.06.2006 02:47:22 |
|
|
Import/Append a table with different field names
I'm not sure if this is possible but someone out there may know a way. I
have about 50 access databases that all have the same field names such as;
FirstName LastName Address City State
I need to import or append or somehow transfer the data that is in the 50
other databases into a single access database that has different field names
but same type of data. Different field names such...
|
2 |
10.06.2006 16:49:41 |
|
|
Syncronize 2 databases
Can someone point me in the right direction?
I have 2 databases on the same server. Each has 2 tables that need to be
identical. "The 2 tables are called agentInfo and officeInfo. One of the
databases gets updated throughout the day and I would like to automatically
update the other database once each night. I was hoping to use a windows
scheduled Task with maybe a macro. I am using a w...
|
1 |
09.06.2006 21:52:01 |
|
|
DSN file and Linked table
Hi,
From Access I have created a new connection to the SQL server. I have
modified the .dsn file to include the username and password information and
"TRUSTED_CONNECTION=No" line. Using this connection I linked a table from SQL
server.
After closing the Access file and re-opening it, when I double click the
link table it tries to open the table with trusted connection and displaying
an...
|
1 |
09.06.2006 19:58:02 |
|
|
Excell additonal formating option (web query)
I am importing a table to a excell spreadsheet. One of the rows is like
this:
HSBC Mtg v Robinson, Mary Ann & Douglas; 1206 Sheridan Av N, Mpls,
55411 22117065
How can I do for this line to become a column after every comma.I will
need a column for every information in between the commas. Could
anybody help me to solve this?
...
|
2 |
09.06.2006 19:40:37 |
|
|
How do you add the auto created key to subsequent tables
This is my first time creating a access application and would like to
use a auto created sequence id when the user first logins in as the key
for each subsequent table entry. I want to push the key out to the
other tables so I don't have redundant data. How would I copy this key
into the other tables? I use forms with sub forms for data entry and
would like for this to happen in the back g...
|
4 |
09.06.2006 19:33:25 |
|
|
Retaining formatting when exporting data from Access to Excel?
When converting an access table to excel it loses it's formatting and
rearranges the columns in alpha order. How can this be prevented?...
|
4 |
09.06.2006 11:39:22 |
|
|
How to export and add data to an Excel worksheet?
I have an Export statement:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9,
"PHQChartQuery", "C:\PHQChart.xls", False
There is a file already in that location named the same thing
I would like to substitute the new data on the worksheet PHQChartQuery that
is already in the file PHQChart.
The reason I would like to do this is I have a graph on that Excel file that
I would...
|
2 |
09.06.2006 06:09:43 |
|
|
Import Text File - can't insert any more field breaks?
hi
I am trying to import a fixed width text file using the wizard into Access
2000 - each line is 884 characters wide, 690 lines in the file. I have
defined 68 fields happily enough until I get to character 486 in the line,
when Access won't let me define any more fields. This is true whether I try
to use the field break feature of the Import Wizard, or manually create the
fields as...
|
2 |
09.06.2006 06:05:31 |
|
|
linking tables question
After reviewing Access Help on how to link a table from another Access file,
I am unsure of how to proceed. Do I have to create a replica table of the
one I want to link to?...or do I just pull the desired table in on its own?
Then...do I have to set up relationships?
Thanks you!...
|
2 |
08.06.2006 20:47:01 |
|
|
I cannot open more than one file. When I open the second one it
I cannot open more than one file. When I open the second one it clears the
first one. I am trying to import objects from one to another. Help
--
TomO...
|
2 |
08.06.2006 18:14:02 |
|
|
exporting to a dbf file
Is it possible to export query results to a dbf file format in Access? I am
using Access 2003 and am not familiar with dbf files, but creating a dbf file
from exported Access data is a requirement for this database. I have
selected File--> Export and picked a file name and when I select a file type
- I have three dBase options. Is this what I would select for a dbf file?
Also, w...
|
4 |
08.06.2006 18:10:28 |