Need Your Opinion - Store/retrieve Word And Excel Files In Access 2003

Sep 4, 2007

Folks I need your help; just wanted to get your opinions here.

I work in a small engineering group and we have lots of reference documents in word and excel which we typically use for any projects. Currently, all these files are stored in Lotus Notes database. Unfortunately, they are pulling the plug on Notes license starting this fall. Therefore, I have been asked to see if there is a way we can store these files in Access as a repository and query the database whenever we need some information.

In order to avoid the database size getting too big, my thought was to store the .xls/.doc files as an “OLE object” data type, keep the files in local hard drive and create a link in a form to give the user to retrieve the information.

Do any of you have any suggestion on what is the best way to handle this?

Your input is highly appreciated.

Shan.

View Replies


ADVERTISEMENT

Pcx Files And Access 2003

Jul 9, 2007

Hello all

This morning I converted an Access 97 db to Access 2003. Unfortunately the db will not now open any .pcx files. Does anybody know if there is there an issue with .pcx files. According to MSDN Access should (and you would expect it to) open .pcx files. I did notice that when office 2003 is installed it does not install the pcx graphics filter PCXIMP32.FLT and it does not appear in the graphics conversion tools download for 2003.

Regards
DennisK

View 1 Replies View Related

Printing Text Files From Access 2003

Mar 6, 2006

Can anyone help? I need to find a way to send text to my printer in Access 2003. All I can find is information regarding printing reports.

View 1 Replies View Related

Can I Mail Merge Word 97 With Access 2003?

Aug 22, 2006

I am wanting to do away with access 97 on a few computers here at work but we cant afford to buy everyone office 2003. Before I buy us access 2003 for a computer I need to know if word 97 will do a mail merge with access 2003. Or could I just buy Office 2003 package for the few computers and it will work that way for a bit more money. I think there would be a compatability issue...

View 3 Replies View Related

Merge Access 2003 To Word 2002

Dec 13, 2006

Hi

I have written an application which uses a query for the current record and then opens a Word document, merges this record and shows the merged document for the user.

all works fine using Office 2003 - when i try it on a pc with Office 2002 - it diesn't work. Something is happening - WINWORD.EXE is running on the process list. But the document doesn't open. I have added the Microsoft Office 10 Office Library to the references but still no joy.

It's a killer - all testing was done on Office 2003 and now a key user wants to use the app - on 2002 and it doesn't work

Any ideas?

cheers

View 1 Replies View Related

Merging Access Data Into Word 2003

Aug 29, 2007

Hi,
how do i get the current record form access 2003 to merge the data into word 2003 template that I created.

The code I'm using is :-

Private Sub Command313_Click()
Dim oApp As Object
Dim doc As Object
Dim strDocName As String

Set oApp = CreateObject("Word.Application")
oApp.Visible = True

strDocName = "K:Supported Living ServicesdatabaseDB-Personnel.dot"
Set doc = oApp.Documents.Open(strDocName)


doc.FormFields("Title").Result = Forms!Personal!Title
doc.FormFields("fristname").Result = Forms!Personal!firstname

Set doc = oApp.Documents.Add(strDocName)

End Sub


I'm using 2 fields here but will be adding a lot more once I got it working.


Thanks inadvance

ps (only a novice at access)

View 4 Replies View Related

Using Files Created In Access 2003 In Access 2000

Nov 30, 2004

Hi:

The company I am consulting with uses Access 2000 and has no intentions of upgrading. I currently do not own Access on my laptop.

I was planning to purchase Access 2003 for my laptop but am concerned that files I create in 2003 might not be "editable" in 2000 even if I choose the 2000 format when creating new databases.

I'm just wondering if anyone has tried creating a file in 2003 (using the 2000 format - as I'm told you can choose what format you want to use) and then edited it in 2000. I want my client to be able to edit the files in 2000 once I've moved on. (I can get 2003 for about the same price as 2000 - so my preference would be to get 2003.) The other obvious reason for going for 2003 is that I could run into the reverse challenge if I own 2000 and my next client uses 2003. At that point, I'd be forced to upgrade to 2003.

My databases are not complex - but do include some customized macros.

Any help, comments... appreciated.

Thx,

dave

View 2 Replies View Related

Modules & VBA :: Store Data From Access Table To Excel Sheet In Corresponding Cells

Jan 28, 2015

I am writing the following code that will first of all display column headers dynamically using "Headers" field data from Access table and then find out the sum(volume) using column header and first column values. The following code works fine to display headers dynamically in Excelsheet from Access table but doesn't display sum(volume) in all the corresponding cells. As I can't attach the Access table so I have stored data from Access table to sheet named "Access Data" as attached. The sheet2 named "Report" should populate total volume .

Code:
Public Function Inputdata()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim r As Long
Dim i As Integer

[code]...

View 2 Replies View Related

General :: Link Excel Files To Access DB

Sep 11, 2012

So I've just started with a company where my job is to manage a ton of data. I am new to Access (2010) and am completely impressed by all the awesome things it can do. However, I am running into some issues with knowing the best way to get my current data (which is all in Excel spreadsheets) into Access.

We are working with about 68 customers in 6 different focus areas (or areas of improvement). To make it easier for them, my company has not required them to enter all their data for each area into a centralized database. Instead, we are pulling reports (into Excel) from 3 different databases. The customers who are not currently submitting data to these databases are sending us Excel spreadsheets with their data (they send a seperate spreadsheet for each focus area). So you can see where my problem lies ... NOTHING is the in the same format. Even then the Excel spreadsheets look different from month to month (and customers submit a new, updated form every month with the current month and previous months) because the people managing the data before I came along changed the format a few different times and the customer has the ability to change them too.

Basically, I would really really really like to be able to just link the Excel files to my database, but I am struggling knowing how to do that with my data in so many different places and forms.

View 3 Replies View Related

Import MS Excel Files Into One Table In MS Access

Jun 27, 2012

Im familiar with Ms Access, but have never used VBA or Scripts. I have 37 Excel files with the same data and would like to import into one file. Data will be received on a monthly basis into the same directory and I would like to automatically upload the data into the same file in Access.

View 1 Replies View Related

Store Word Document In A Variable

May 10, 2005

hi,

Is there a way to store the text of a word document in a variable without opening the document?

I explain:
I have document1.doc opened
I want to copy and paste the contain of document2.doc at the end of document1.doc without opening document2.doc

I ve tried to use

Open "document2.doc" For Input As #1
Do While Not EOF(3)
Line Input #3, temp
tempstr = tempstr & temp
Loop
Close #3

but I don t get the result

Any idea?

View 2 Replies View Related

I Cant Import Excel Data Into Access 2003

Jan 15, 2007

When I try to import from a spreadsheet, Access crashes. No errors, no error log entry. At first I thought it was because my file was password protected, so I tried a new file with no password, but it still crashes Access.:confused:

View 2 Replies View Related

Error Upading Excel With Access 2003

Apr 28, 2006

I recently updated my version of Access 2003 with the latest patches. I have a linked excel spreadsheet that I update using a query. The linked spreadsheet no longer allows editing since the update. Anyone encounter this problem - know of a work around?

Thanks

View 1 Replies View Related

Importing Excel Table To Access 2003

Jan 22, 2007

Hi!

I was importing the large array of accounting data into Access from Excel through File - Get External Data - Import. Several columns contained tangible accounting data (e.g. registration numbers) that had different formats like "23423 34", "32-3545" and in some cases even contained letter constants. Therefore, I have assigned TEXT type to this column while importing and was sure that all values are going to be stored as text. However, what has happened is: 18307769 turned into 1.83078e+007! this means tangible accounting data that was used as a key field for further linking turned into bull&&$%! :-(

I know this problem is very simple, so please, can you give me a hint as to how do I solve it in the future.

Thank you in advance.

--
Regards,
vb707
merchant credit card processing

View 1 Replies View Related

Modules & VBA :: Saving Excel Files Through Access In Particular Directory

May 4, 2014

I am using Access to save an Excel file in a particular directory. The code was created about 10 years ago and hence saves the file with .xls extension and I would like to save with a .xlsm extension. If I just change the .xls to .xlsm, in the code below, the file is saved but the Compatibility Checker comes up (I would like to stop this) and when the file is reopened I get an error message stating there is a file extension problem and the file won't open.

Code:
strExt = ".xls"
'If .txtFriendlyName <> "" Then
' strDestFileName = .txtFriendlyName
'Else
' strDestFileName = Left(objFile.Name, Len(objFile.Name) - 4) & MakeFilePosfix(Now())

[Code] ....

View 7 Replies View Related

Importing Large Text Files From Excel Into Access

Dec 1, 2012

I have a data file I am importing into MS Access 2010. One of the fields is a large text field. When i import that field into Access the text is getting cut off. How do I get the full text field to import without cutting off?

View 6 Replies View Related

Access Query - Export To Multiple Excel Files

May 21, 2015

I have a basic access query (MACs Report Template) that I need to export into multiple excel files based on the 1st field (Plan ID).

Example:

PLAN ID
Number
Amount
Status

AM141
12345
100
Disconnected

AM141
54321
5000
Active

AM142
11122
2000
Disconnected

AM155
22334
500
Disconnected

I need this to create a spreadsheet for each unique PLAN ID. Ideally i want it to export the following:

MACs Report AM141 20150521.xls (both records above should be in this report)
MACs Report AM142 20150521.xls
MACs Report AM155 20150521.xls

View 3 Replies View Related

How To Import Multiple Excel Files Into One Access Table

Mar 25, 2014

I have a lot of Excel files and each of them has 3 sheets that I would like to import in Access 2010. How can I import them without having to do one by one?

I always get error on

Code : Application.FileSearch

View 1 Replies View Related

Modules & VBA :: How To Browse Files And Store Them To Database

Jun 10, 2015

i want to browse the files from a form and then store hem to the database.i have the following code, i can show the file path to the text box but i don't know how to store the file or how to upload the file to the database.

Dim f As Object
Dim strFile As String
Dim strFolder As String
Dim varItem As Variant

[code]....

View 5 Replies View Related

Tables :: Cannot Import Data From Excel Into Access 2003

Feb 5, 2014

when i import data from excel into access 2003.i give nothing means not import data and no error seen like process finished but nothing happend.

View 2 Replies View Related

Import Multiple Excel Files Into Single Access Table

Jan 23, 2008

Hello,

I have some data in excel which I am importing it into MS Access 2002. Each excel file (one worksheet per file) is imported into separate tables.

I want to combine all my imported tables into one table. Is that possible, if yes then how and if no then what can be done to get single table after impoting data from various excel files.

Cheers,
Mandeep

View 14 Replies View Related

General :: How To Break Up A Table In Access Into Several Linked Excel Files

May 3, 2013

What is the strategy for doing this rather than the code (if it's possible)? I can code a fair bit of VBA in excel but I'm not too sure about what I'm doing in Access.

View 1 Replies View Related

Modules & VBA :: Convert To Excel Files And Import Into Access Database

Aug 7, 2015

I have files that have extension of TSV which are text files but viewable in exel. I figured out a way for the user to click on a button in Access which does the following

1. Run Macro in Excel: The macro prompts the user to select the TSV file. After selection, macro opens the employee.tsv file in the excel (with excel being invisible) and saves it as employee.xls

Code:
Sub SaveTSVtoXLS()
Dim myPath As String
Dim myString As Variant
Application.DisplayAlerts = False
With Application.FileDialog(msoFileDialogOpen)

[Code] .....

2. Imports the Excel file (employee.xls) into two tables: tblEmployee and tblDepartment using the following codes.

Code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "qryDepartment", selectFile, True - 1, "A1:C2"
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "qryEmployee", selectFile, True - 1, "A1:AE2"

Everything is working flawless except that the user has to select the file three times:

1 time for the tsv
2 times for the xls file

Is there a way that the user can select the file only once (tsv file) or at least only twice one of the tsv file and the other for the xls file?

View 8 Replies View Related

Attaching WP, Excel, Adobe Files To An Access Database Form Using A Control Key

Oct 18, 2006

Is it possible to attach a WP, Excel, or Adobe file to a form, possibly by using a control key? How?

View 6 Replies View Related

Exporting Access 2003 Report To Excel Truncates Memmo Field

Jan 10, 2005

When I export a report to Excel, a memmo field is truncated to 256 characters. If I export the query behind the report, the memmo field is exported correctly. Is there a way to export an Access 2003 report to Excel and maintain all of the data and report formating in memmo fields?

View 1 Replies View Related

Adding Word Files

Feb 24, 2006

Hi there,

I am just contimplating the best way to add word files into my database. I know you can add them as objects, however when they appear on the form they seem a bit 'messy'.

Does anyone have anytips how to make this look more professional, perhaps the use of links, or buttons?

Many thanks in advance, Ross

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved