|
how to import a text file having "|" delimiters into access
Please Help..
I need to import a text file having "|" (pipe separators) inti access
database.
Example :
Q29290006|000026173|046|
...
|
2 |
09.07.2006 19:09:11 |
|
|
Uploading an HTML File to a website
I use the following code to upload an html file to a website triggered at
regular intervals by the on timer property of a form.
This works OK until for any reason the website cannot be reached when I get
a runtime error which halts the routine until the error message is cleared
manualy.
Is there any way of automatically accepting the message and simply closing
the form so that it will t...
|
1 |
08.07.2006 14:51:01 |
|
|
How do I import mainframe reports into an Access database?
I'm using reports generated from mainframe accounting systems but am using an
Access DB to generate reports. Currently the process of generating these
reports by other means has been labor intensive. I'm hoping that Access will
allow me a greater ease of report production with tremendous time savings.
My manual and online Access help has returned no clear explanation.
Current process...
|
5 |
08.07.2006 14:00:01 |
|
|
How do I delete a field name from a linked table in Access?
My source database changed. Some fields were deleted which is blowing up my
linked tables. How can I edit this? I inherited the Access 2003 db and I'm
not very familiar with it. I've tried recreating the link but the source db
is restricted to allow on 50,000 records to be extracted at a time. I don't
know how to write that kind of query. ...
|
3 |
08.07.2006 01:42:27 |
|
|
Can I modify record information from an ODBC connection in Access
I have an ODBC connection to tables in MS-SQL Server. Is it possibly for my
profile to be set up on the Enterprise Manager to have access to modify
records from Access? I currently have DB-Datareader rights, but what if I
had DB-Owner rights? Could I modify the records if I am looking at the tables
in Access? Is this possible?
Thanks for your input!!!!...
|
2 |
08.07.2006 01:34:26 |
|
|
access importing a text file with quotes
I am importing a text file and the field values are enclosed in ""
(quotation) marks. Is there any way to have Access recognize the quotations,
ignore them and import just the field values?
Thanks for your help....
|
5 |
07.07.2006 21:56:02 |
|
|
Create Specs
Hello all,
This is a complicated problem. I'll try to explain what I'm trying to
achieve.
1. I have an Excel file which has specifications for text file we would
like to import in Access, it has field names, start and width.
2. I run a code to get these specs in the format of Access (when we
click on Advanced)
3. I create a Blank Access database (SpecsTbl) from VBA, create tables
MSysIME...
|
4 |
07.07.2006 19:09:34 |
|
|
Export data from Outlook to Excel
I have a shared contact list that is located in a public folder on our
network and I am the administrator. I want to export data from a specific
group in the shared contact list to an excel spreadsheet so that I can use
the data to mail merge labels. I was not able to access this list at all,
nor could I see any catagories or groups. Also within the list are self
created fields that a...
|
1 |
07.07.2006 17:48:02 |
|
|
Importing and setting up Database
First of all i am having trouble setting up a database. Basically what i want
to do if i can is Import an Excel database onto a new Access database. If
this is not possible (and this may be a dumb question) is set up a new
database in Access but am having trouble with this! Can you help please?
Regards
Kaye Jackson...
|
2 |
07.07.2006 17:17:02 |
|
|
Linked table Manager; how can I automate changing of the linked ta
sI have a database I use to do my budget each year it is called
BudgetDatabase.mdb it contains all my FORM, REPORT, QUERIES. In another
Database is where all my data is stored; actually I one for each year... my
2005 data is stored in 2005Data.mdb, my 2006 data is stored in 2006Data.mdb.
I use the Linked Table Managed to link to the database I want. But, I want
others to use this databa...
|
3 |
07.07.2006 13:31:02 |
|
|
Help!!! Excel column is invalid when spreadsheet is linked as a ta
Hi,
I'm having a very rare, but deadly problem with Excel and Access. Every
day, I get data in an application-generated Excel sheet with always the same
structure, and I link it into an Access database by using the command:
DoCmd.TransferSpreadsheet acLink, , "tbInput", strPathAndFileName, False
I process that linked table with VBA code and store some of its columns and
data in ano...
|
3 |
07.07.2006 11:52:01 |
|
|
Importing Data
Hi,
I need to import some data from text files and from Excell files all
months into my DB.
I want to put one button to do this operation, but i don't know waht is
the code that i need to put in the on click operation.
Can any one help me with this?
Thanx,
...
|
2 |
07.07.2006 09:46:55 |
|
|
Importing from Excel to an existing table / updating a table
I am new to access so don't know what is possible or where to look.
I need to create a spreadsheet to imput the data into and then have it
import it into an existing access database. How do I go about this?
Is it possible to import a spread sheet and only update cells that have
changed for a record?...
|
2 |
07.07.2006 03:46:35 |
|
|
Import Act! 6 to MS outlook contact manager
I would like to find a patch or fix for importing Act!6 to MS outlook...
|
1 |
06.07.2006 23:09:01 |
|
|
Fail to import because a field includes delimiter
Dear All,
I export a table with delimiter "|" to a text file from Informix database.
Some fileds include Chinese words. And some Chinese words include "|". It is
no problem to import it back to Informix.
When I import it with delimiter "|" into Access 2002, it fails because some
fileds include the delimiter "|". If I remove the delimiter "|" from the text
file, it casues the Chinese ...
|
2 |
06.07.2006 20:24:56 |
|
|
Importing and that "Invalid argument" problem.
I am having a lot of trouble importing data into Access 2003. I am sick of
the invalid argument message to the point where I took a table, exported the
data to a csv file, deleted the data in the table, removed the indexes and
any primary keys, saved the table design, and I'm trying to import the data
that just came out of the database in the first place.
My database is small, about 3 ...
|
5 |
06.07.2006 17:57:01 |
|
|
Output To Method using Specs
Hi all,
I need to export multiple tables to text files every month. It's not that
hard to do Save As/Export, go thru the wizard and choose my specs but i was
wondering if it was possible to use the Output To method using your specs
you already have created.
TIA
Ted
...
|
2 |
06.07.2006 16:07:37 |
|
|
Export Query to .txt - Right align number
I am trying to export a query to a .txt file. I can't get the number field to
right align. Any help would be appreciated.
...
|
1 |
06.07.2006 15:06:01 |
|
|
How do I use VBA to automatically export a query to Excel?
For a user-friendly environment, I want to set up a command button to
automatically export a query into Excel. Please advise the VBA needed. ...
|
2 |
06.07.2006 12:30:01 |
|
|
Appending Txt files coding
I can open a file but the file is not passing through with the code. Do I
need to write file and not line as follows:
Private Sub CreateAfile_Click()
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateTextFile("c:\testfile.txt", True)
a.Writeline ("C:\Direct Debits\strFile2.txt")
a.Close
End Sub
"Nadine" wrote:
> Thanks for that I will try and let you...
|
2 |
06.07.2006 12:11:02 |
|
|
How can I stop access adding records in the middle of a table?
I have a form database which is linked to a table databse.
I created a new table in the table database from the form database using a
make table query (to split data into old and new records). Now when my users
add new records they are added to in front of the records, but in order....
so I get:
123, 124, 125, 1, 2, 3, 4, 5, 6 ...
The next record added will mean I get;
123, 124, 125, ...
|
4 |
06.07.2006 11:17:16 |
|
|
ODBC -- call failed
Hello experts,
I have some Access forms with queries linked through ODBC connection to
Oracle. Everything was working fine and all of a sudden I start getting the
following error message:
*************
ODBC -- call failed,
[Microsoft] [ODBC Driver Manager] Function sequence error (#0)
*************
Here is my platform:
Windows XP Pro, Access 2003 with SP2, Oracle8i Enterprise ...
|
3 |
05.07.2006 23:41:01 |
|
|
merge two access database tables into one table
I have multiple databases that I want to merge into one table - I do not want
to use query - Any suggestions - thanks for any help....
|
2 |
05.07.2006 22:34:03 |
|
|
CHECK "Out of Office" using VBA
Within an access-app I want to check whether a user is "Out of Office"
without having a Outlook security - pop-up.
Can anybody help me?...
|
2 |
05.07.2006 18:41:26 |
|
|
Access adds new table when importing data
I work in a hospital lab. One of the analysers we use saves test data in a
new access database for each day.
I've written a macro to import the database into a user interface. When it
imports the new DB it duplicates the tables with the new data and adds a
number to the table name, e.g Specimen, Specimen1, Specimen2...
I have had to add steps to the macro to rename and delete the duplica...
|
2 |
05.07.2006 18:38:33 |