Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 03-11-2010
Member
 
Join Date: Sep 2010
Posts: 19
Why it takes so much linked Excel tables in an Access DB?

I need the database to include data from a other table (one per month and vehicle series) for an annual review to summarize. Since the database also available to others I have made it as easy as possible, so I have all the Excel spreadsheets that are created out everything from impromptu already been created and linked. The user must now replace the old table in the folder and can be output on the DB, the linked data ready for the charts. So I think everything I've done so far executed, a question launches as the whole? with a call to the DB? I still need this part:
Code:
Dim db As Database, rs As Recordset, strNewPath String 

 strNewPath = "D: \\ New" 

 Set db = CurrentDb 

 Set rs = CurrentDb (tblExcelTable)
I have the fact completely removed. I have entered all of Visual Basic. I must now create a macro or even add commands in the autoexec add? Please help me.
Reply With Quote
  #2  
Old 03-11-2010
Member
 
Join Date: Feb 2009
Posts: 40
Re: Why it takes so much linked Excel tables in an Access DB?

And that can not be in a table in the Access database ? Create it. I would import the Excel data tables. If you're in the MDB Front and back split, you have the users only the to give the front end. In the backend is the data. That you can do as you like. When calling the DB, the start the main form. Somewhere the call Call Excel_Link mentioned be. If the paths match, the rest should go all by itself. The after integration speed you could still a little. Show create form with progress bar and leave.
Reply With Quote
  #3  
Old 03-11-2010
Member
 
Join Date: Sep 2010
Posts: 19
Re: Why it takes so much linked Excel tables in an Access DB?

I find no excel_link call, let alone excel_link * help * but when I viewed VBA I have at the top:
Code:
Option Compare Database 
Public Function Excel_Link () 
On Error GoTo error: 

Do Until rs.EOF 
Call TableDelete (rs! tabname) 
Call TableRelink (rs! path names & rs! Filename Specifies, rs! Tabname) 
rs.MoveNext 
Loop 

exit_Excel_Link: 
Exit Function 
Error: 
MsgBox "Error:" & Err.Number & "" & Err.Description & "Excel_Link ()" 
Resume exit_Excel_Link 
End Function
I click on Public Function Excel_Link (). I see the drop down menu over it. (General) and also in times of instant Excel_Link.
Reply With Quote
  #4  
Old 03-11-2010
Member
 
Join Date: Apr 2008
Posts: 240
Re: Why it takes so much linked Excel tables in an Access DB?

Does not matter, everyone has to start small. There must be another Option Explicit with pure. In the VBA Editor> Tools> Options> [X] variable declaration
required to activate. Then, the future is in there in each module. Is also very important. With the Call function is called:
Call Excel_Link ()
Well, it is clear that as badges. When you give then click in the Event Procedure Call Excel_Link on.
Reply With Quote
  #5  
Old 03-11-2010
Member
 
Join Date: Apr 2008
Posts: 242
Re: Why it takes so much linked Excel tables in an Access DB?

No, you have to rewrite anything. Here a variable is declared only in this function is used. The content comes from the calling function - Call TableRelink (rs! path names & rs! Filename Specifies, rs! Tabname) rs! path names & rs! filename Specifies strNewPath as are the contents of string. Marking but sometimes the line Public Function and press F9. The line RED should now be marked, call the function Excel_Link on, the Debugger is now on the Red line. If you now with the strNewPath mouse you can race on and wait 2 seconds, you see the Contents of the variable strNewPath. You should get yourself a book up and deal with the basics, work easier immensely.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Why it takes so much linked Excel tables in an Access DB?"
Thread Thread Starter Forum Replies Last Post
How to Link Excel Tables with each other Iyyappan MS Office Support 2 23-02-2012 05:57 PM
SQL query between 2 tables linked by many to many relationship Luis234 Software Development 2 09-05-2009 02:17 PM
Unable to access linked Excel file from shared Excel file on server AK_Chopra Windows Software 4 07-05-2009 02:09 PM
Auto filling linked data from another table in Excel 2007 Samarth Software Development 2 25-12-2008 08:04 PM


All times are GMT +5.5. The time now is 08:35 AM.