Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Importing data from access to excel. in microsoft.public.access.externaldata
Started 1 month, 2 weeks ago by Imani
Whenever I import access data into excel, cell addresses I want to use in any formulas have odd names. Instead of d3, etc, if the access document was called 'work file', the cell would be 'Work_file' and have something saying line 142. Is this normal and can this behavior be changed?...
Site: Discussions in microsoft.public.access.externaldata  Discussions in microsoft.public.access.externaldata - site profile
Forum: microsoft.public.access.externaldata  microsoft.public.access.externaldata - forum profile
Total authors: 2 authors
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

GBA replied 1 month, 2 weeks ago
well you 'export' out of access to excel and 'import' excel into access the best literal export to excel is from a query (or a table). if you are exporting from a report - then the way excel interprets it isn't always clear. with Access2007 one can not export a report to excel... not sure this helps but just ...
Size: 1,151 bytes
Customize:  Customize "<b>Reply 1</b>: Importing data from access to excel. in microsoft.public.access.externaldata :: microsoft.public.access.externaldata :: Discussions in microsoft.public.access.externaldat..."

 

Top contributing authors

Name
Posts
GBA
1
user's latest post:
Importing data from access to...
Published (2009-11-03 15:54:00)
&nbsp; well you 'export' out of access to excel and 'import' excel into access the best literal export to excel is from a query (or a table). if you are exporting from a report - then the way excel interprets it isn't always clear. with Access2007 one can not export a report to excel... not sure this helps but just thought I would throw this in..... &quot;Imani&quot; wrote: &gt; Whenever I import...
Imani
1
user's latest post:
Importing data from access to...
Published (2009-11-03 03:08:00)
&nbsp; Whenever I import access data into excel, cell addresses I want to use in any formulas have odd names. Instead of d3, etc, if the access document was called 'work file', the cell would be 'Work_file' and have something saying line 142. Is this normal and can this behavior be changed? &nbsp;

Related threads on "Discussions in microsoft.public.access.externaldata":

Importing excel to Access in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Importing excel to Access in microsoft.public.access.externaldata
Importing excel to Access in microsoft.public.access.externaldata
Problems Importing Excel Files to an Existing Table in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Problems Importing Excel Files to an Existing Table in microsoft.public.access.externaldata
Problems Importing Excel Files to an Existing Table in microsoft.public.access.externaldata
Importing Excel Data with Drop down lists in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Importing Excel Data with Drop down lists in microsoft.public.access.externaldata
Importing Excel Data with Drop down lists in microsoft.public.access.externaldata
Importing Excel file into an existing form in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Importing Excel file into an existing form in microsoft.public.access.externaldata
Importing Excel file into an existing form in microsoft.public.access.externaldata
Carriage return error when importing excel into access...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Carriage return error when importing excel into access in microsoft.public.access.externaldata
Carriage return error when importing excel into access in microsoft.public.access.externaldata
Importing Excel File into Access using the wizard in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Importing Excel File into Access using the wizard in microsoft.public.access.externaldata
Importing Excel File into Access using the wizard in microsoft.public.access.externaldata
Importing Excel '03 files into Access '00 in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Importing Excel '03 files into Access '00 in microsoft.public.access.externaldata
Importing Excel '03 files into Access '00 in microsoft.public.access.externaldata
Importing Excel Files, getting Invalid Argument in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Importing Excel Files, getting Invalid Argument in microsoft.public.access.externaldata
Importing Excel Files, getting Invalid Argument in microsoft.public.access.externaldata
Importing excel data in microsoft.public.access.externaldata  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Importing excel data in microsoft.public.access.externaldata
Importing excel data in microsoft.public.access.externaldata
Error when importing Excel 07 sheet in...  Discussions in microsoft.public.access.externaldata - site profile microsoft.public.access.externaldata - forum profile Error when importing Excel 07 sheet in microsoft.public.access.externaldata
Error when importing Excel 07 sheet in microsoft.public.access.externaldata

Related threads on other sites:

Importing Excel 2007 document only works when Excel is...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Importing Excel 2007 document only works when Excel is open in microsoft.public.access
Importing Excel 2007 document only works when Excel is open in microsoft.public.access
Importing Excel Files into Microsoft Money Plus Deluxe...  Discussions in microsoft.public.money - site profile microsoft.public.money - forum profile Importing Excel Files into Microsoft Money Plus Deluxe 2008 in microsoft.public.money
Importing Excel Files into Microsoft Money Plus Deluxe 2008 in microsoft.public.money
Importing Excel data into SQL 2008 Express server? in...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.server - site profile microsoft.public.sqlserver.server - forum profile Importing Excel data into SQL 2008 Express server? in microsoft.public.sqlserver.server
Importing Excel data into SQL 2008 Express server? in microsoft.public.sqlserver.server
Importing Excel workbooks in...  Discussions in microsoft.public.access.setupconfig - site profile microsoft.public.access.setupconfig - forum profile Importing Excel workbooks in microsoft.public.access.setupconfig
Importing Excel workbooks in microsoft.public.access.setupconfig
Importing Excel Chart in...  Discussions in microsoft.public.word.drawing.graphics - site profile microsoft.public.word.drawing.graphics - forum profile Importing Excel Chart in microsoft.public.word.drawing.graphics
Importing Excel Chart in microsoft.public.word.drawing.graphics
Conversion error on importing Excel spreadsheet in...  Discussions in microsoft.public.access.macros - site profile microsoft.public.access.macros - forum profile Conversion error on importing Excel spreadsheet in microsoft.public.access.macros
Conversion error on importing Excel spreadsheet in microsoft.public.access.macros
Importing Excel Table to Access in...  Discussions in microsoft.public.access.macros - site profile microsoft.public.access.macros - forum profile Importing Excel Table to Access in microsoft.public.access.macros
Importing Excel Table to Access in microsoft.public.access.macros
Importing Excel Spreadsheet into Access and Changing...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Importing Excel Spreadsheet into Access and Changing Field Propert in microsoft.public.access
Importing Excel Spreadsheet into Access and Changing Field Propert in microsoft.public.access
Error Importing Excel Spreadsheet into Access in...  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Error Importing Excel Spreadsheet into Access in microsoft.public.access
Error Importing Excel Spreadsheet into Access in microsoft.public.access
Importing excel symbols in microsoft.public.access  Discussions in microsoft.public.access - site profile microsoft.public.access - forum profile Importing excel symbols in microsoft.public.access
Importing excel symbols in microsoft.public.access
Thread profile page for "Importing data from access to excel. in microsoft.public.access.externaldata" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Importing data from access to excel. in microsoft.public.access.externaldata", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity