Link Excel documents in Access to create one report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to link 52 separate Excel documents to create one report. Can someone
provide the steps for me.

Thanks,
 
Jodi said:
I have to link 52 separate Excel documents to create one report. Can
someone
provide the steps for me.

Thanks,
Click to expand...

Step 1: Link to spreadsheet number 1
Step 2: Link to spreadsheet number 2
Step 3: Link to spreadsheet number 3
Step 4: Link to spreadsheet number 4
Step 5: Link to spreadsheet number 5
Step 6: Link to spreadsheet number 6
Step 7: Link to spreadsheet number 7
Step 8: Link to spreadsheet number 8
Step 9: Link to spreadsheet number 9
Step 10: Link to spreadsheet number 10
Step 11: Link to spreadsheet number 11
Step 12: Link to spreadsheet number 12
Step 13: Link to spreadsheet number 13
Step 14: Link to spreadsheet number 14
Step 15: Link to spreadsheet number 15
Step 16: Link to spreadsheet number 16
Step 17: Link to spreadsheet number 17
Step 18: Link to spreadsheet number 18
Step 19: Link to spreadsheet number 19
Step 20: Link to spreadsheet number 20
Step 21: Link to spreadsheet number 21
Step 22: Link to spreadsheet number 22
Step 23: Link to spreadsheet number 23
Step 24: Link to spreadsheet number 24
Step 25: Link to spreadsheet number 25
Step 26: Link to spreadsheet number 26
Step 27: Link to spreadsheet number 27
Step 28: Link to spreadsheet number 28
Step 29: Link to spreadsheet number 29
Step 30: Link to spreadsheet number 30
Step 31: Link to spreadsheet number 31
Step 32: Link to spreadsheet number 32
Step 33: Link to spreadsheet number 33
Step 34: Link to spreadsheet number 34
Step 35: Link to spreadsheet number 35
Step 36: Link to spreadsheet number 36
Step 37: Link to spreadsheet number 37
Step 38: Link to spreadsheet number 38
Step 39: Link to spreadsheet number 39
Step 40: Link to spreadsheet number 40
Step 41: Link to spreadsheet number 41
Step 42: Link to spreadsheet number 42
Step 43: Link to spreadsheet number 43
Step 44: Link to spreadsheet number 44
Step 45: Link to spreadsheet number 45
Step 46: Link to spreadsheet number 46
Step 47: Link to spreadsheet number 47
Step 48: Link to spreadsheet number 48
Step 49: Link to spreadsheet number 49
Step 50: Link to spreadsheet number 50
Step 51: Link to spreadsheet number 51
Step 52: Link to spreadsheet number 52

Step 53: Run your report.


HTH
Steve
 
Not necessarily. You can generate output like that at the command
prompt.

If Perl is installed:
perl -le"print qq(Step $_: Link to spreadsheet number $_) for (1..52);"

Or from the Windows shell (assuming the command extensions are enabled):
ECHO OFF
FOR /L %1 IN (1,1,52) DO ECHO Step %1: Link to spreadsheet number %1
ECHO ON

I guess I have too much time on my hands too...
 
Back
Top