Word VBA, Insert fields from Excell or Access

microsoft.public.word.vba.general - Microsoft office word


Word VBA >> Insert fields from Excell or Access

by TWFyaw » Wed, 04 Aug 2004 10:15:01 GMT

Is there a way to insert fields from an Excell or Access file into a Word document? I want to enter data into a spreadsheet and then insert it into a Word document.

Top

Word VBA >> Insert fields from Excell or Access

by DA » Wed, 04 Aug 2004 10:39:05 GMT


Hi Mark

Short answer - yes.
Have a look at the following links. They'll give you some
tuition and samples on how to get data from Excell and
Access.

http://word.mvps.org/FAQs/InterDev/GetDataFromDB.htm
http://word.mvps.org/FAQs/InterDev/XLToWordWithDAO.htm

All the best,
Dennis

file into a Word document? I want to enter data into a
spreadsheet and then insert it into a Word document.


Top
Similar Threads

1. Import excell sheet into access, then add new fields to access MDB - Microsoft Office Access

2. Excell data input form that links to/inserts data to Access Databa 

We have a Job Database (400 entries right now) that contains all manner of 
info for jobs. 

What I would like to know is if there is a way to make an Excell(03/07) 
Input form that links to the DB (Access 07) and inputs the data in the 
appropriate location. For instance so that a Project Manager can submit info 
on a new job without having to actually get into the database (very scary 
thought lol).

I am not a Pro at Access, nor Excell per-say. I know my way around both 
fairly well though.

Thanks in advance

3. Inserting a excel spreadsheet into an Access OLE Object fields

4. Inserting Pictures from Access OLE Object field 

XL97

Hi all

I have some bitmaps stored in an access OLE Object field. 
Is there a way to add these to a sheet?

I guess what it boils down to is, is there another method 
of adding a picture without supplying a filename? Failing 
this, I guess I could save the pictures with the workbook 
and duplicate them where necessary.

Thanks for any help

Rog

5. insert query into excell sheet to update excell sheet and pivot table - Excel

6. Access Insert - Syntax Error for field "DATE" but not for "DATE1" 

objConn = New ADODB.Connection
objConn.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dbPath _
& ";Jet OLEDB:Database Password=" & dbPassword)

This cause error:  (VB.NET. )

    sqlString = "insert into table1 " _
       & "(Date1,Time,Ext,Co) values " _
    & "('04/04/05','06:02PM','101','01');"



But below is fine

   sqlString = "insert into table1 " _
& "(Date1,'Time1,Ext,Co) values " _
& "('04/04/05','06:02PM','101','01');"


That is , if I change the Access Table filed name
 from "Date" -> Date1
"Time" -> "Time1". Then the above code run through fine.


But in my VB6 code before,  I used the same TABLE Field Name and it works.
(That was a different VB project, of course)

7. Inserting number fields into a table in an Access MDB using VBScript

8. Insert bitmap into access database field 

Hello,

I need to Add and/or Insert a bitmap (C:\Test.bmp) into a new or existing 
access database record  (Employee.dig_signature) and have it saved as a 
bitmap image.
I am currently using this statement in a click event.

rs.AddNew
rs.Fields("employee_signature").Value = pByteA
rs.Update

but it is saved as  long binary data. How can I save this the way I need it?

Thanks

Rick