CSV to multiple tables update
Fri, 12 Sep 2008 01:26:00 -0700
I have access to a flat CSV file daily from where I query my stock data. This
way I was storing several tables on my DB and experiencing some difficulties.
TABLE [20080901]
Product warehouse1 warehouse2
123456789 50 50
987654321 15 10
012345678 5 5
753951456 12 12
Someone here at the forums to ...
|
import excel file to separate tables in access data base
Thu, 11 Sep 2008 23:12:01 -0700
Hello,
each day i want to import 1 excel file to my data base, this excel will be
updated each day, and information of this excel file must be imported/append
in 3 separated tables. it means some columns in 1st table some others in 2st
table and rest of them in third one, how can do this authomaticly by code ...
|
CSV Import with duplicate field names
Thu, 11 Sep 2008 18:04:11 -0700 (PDT)
I am trying to import a CSV file in VBA and am having a few problems
with one of the imports. The .csv file contains row headers and there
are 7 rows titled "Descriptive Text." When I try to run the code:
DoCmd.TransferText transfertype:=acImportDelim, _
TableName:=strTable, _
FileName:=st ...
|
Importing Problem when importing a table
Thu, 11 Sep 2008 13:58:06 -0700
I have a database that I import tables into. I have had no problems
importing Excel spreadsheets into these tables in the past. However, we are
training people from Argentina to do this same process in their office. They
use the same database and the same Excel spreadsheet and when they try to
import the ...
|
Importing text file
Thu, 11 Sep 2008 11:02:03 -0700
I would like to import a fixed-width text file into an all-text table.
I already have a table with the correct text field sizes, but of course when
I run the Get External Data>import function, I am presented with a field
list, with field types and sizes which represents Access's best guess as to
what the tabl ...
|
need large message in Message Text of send object
Wed, 10 Sep 2008 23:41:01 -0700
Hi All
I want to use SendObject to send an instruction message to contractors. The
form contains all the info I need to include in the email, but I want to have
more than a one line email.
How can I put a full message in that field? I want to have proper parragraph
spacing in with the form fields in the ...
|
where to find Microsoft Jet.OLEDB.4.0?
Wed, 10 Sep 2008 21:19:01 -0700
I am working in a 2008 VB.NET application that is connecting to an Access
2007 database, the application is telling me that the Microsoft.Jet.OLEDB.4.0
provider is not registered in the local machine. ...
|
|
|
how do I link a table to a text file containing asian characters?
Wed, 10 Sep 2008 17:14:04 -0700
I have performed a data extract from our ERP ustilizing a report writer that
refreshes daily and saves the file as a text file to a local drive. I have
created a dbase that uses the "link table" command to the text file, however
- upon opening the file - the data gets cutoff at the first "special"
character ...
|
yes/no = true false when merged
Wed, 10 Sep 2008 09:01:01 -0700
I am trying to merge an access quary to a word document. The fields with the
check box come up as true/false. how do I get it to show yes/no. ...
|
ADD New Question
Tue, 9 Sep 2008 19:43:01 -0700
Just learning to use ADO. The code example below illustrates what I'd like to
do using ADO, though I'm not sure quite how to do it.
Dim db As DAO.Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("tblMyTable", dbOpenDynaset)
rs.AddNew
rs!MyField1= Me.Fiel ...
|
