Thread: SQL Server
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default SQL Server

Excel doesn't have book marks but youo could embed the word document into an
excel worksheet. Then use the workbook as a templete to get your data. Use
ACTIVATE to open the embedded word document.

Now Excel could be the SQL database. Really the structure of an Excel
Workbook and an Access table is identical. it is just the default
application that is run. Your database open statement can either point to a
MDB file or a XLS file. An Excel worksheet is an Access Table. A cell in a
worksheet is a cell in an access table. The Head row in an excel worksheet
is the table headings in access.

"Andy Smith" wrote:

Hiya,

We had some templates in Word built before my time, which use Bookmarks to
match fields in a SQL Database. Does Excel has such 'bookmark' functionality
or an equivalent, as I was hoping to copy the code into an Excel template for
Invoices.

If not, I have tried embedding an Excel object into an existing Word
template, but the only problem is the object doesn't span across multiple
pages; once it becomes to big, the whole thing jumps onto a new page. Can
this be stopped?

Thanks