microsoft.public.access
back to index
From: "Arvin Meyer [MVP]"
Date: Friday, October 19, 2007 5:17 PM
Subject: Re: How do I convert Excel 2007 Spreadsheet to Access 2007 database?
I spoke too soon. I forgot that Peter Hibbs has a utility that may help:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Excel%20to%20Access%20Converter%20Utility%20program'
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"Arvin Meyer [MVP]"
news:egrkohoEIHA.1056@TK2MSFTNGP03.phx.gbl...
> Excel has never been automatically convertible. Import the Excel
> spreadsheet as an Access table then create new, empty tables in Access and
> import the data into them as needed.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> "DaveG"
> news:AD374AB9-1536-48AE-A776-5E342CDF1297@microsoft.com...
>>I used to be able to conver earlier versions of Excel spreadsheets to MS
>> Access. How do you do this with Excel 2007 & Access 2007?
>
>
