ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing EXCEL file into access (https://www.excelbanter.com/excel-discussion-misc-queries/76989-importing-excel-file-into-access.html)

schleppy2

Importing EXCEL file into access
 

Hello all..
quick question. I am not sure if this is possible or not...

I would like to take various spreadsheets I have and import them into
access. The trick is, I want to use the formats and all.. Not just
the data. Essentially when I print a report, I want it to look just
like the excel file would have while having the ability to track
Projects hours etc.. instead of having to save off an excel file, I
would like to able to track all my hours, projects etc.. in (1)
database while still having the ability to print off timesheets,
reports etc...
thanks in advanve


--
schleppy2
------------------------------------------------------------------------
schleppy2's Profile: http://www.excelforum.com/member.php...o&userid=27013
View this thread: http://www.excelforum.com/showthread...hreadid=521920


Paul Lautman

Importing EXCEL file into access
 
schleppy2 wrote:
Hello all..
quick question. I am not sure if this is possible or not...

I would like to take various spreadsheets I have and import them into
access. The trick is, I want to use the formats and all.. Not just
the data. Essentially when I print a report, I want it to look just
like the excel file would have while having the ability to track
Projects hours etc.. instead of having to save off an excel file, I
would like to able to track all my hours, projects etc.. in (1)
database while still having the ability to print off timesheets,
reports etc...
thanks in advanve


Maybe exporting in XML format?




All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com