ormatting Imported data from Access 03

Hi all,

I have data from a access DB that i am exporting into a table in excel.
 This table keeps track of samples and what testing has been done to
them in a lab.  When the data is refreshed the formatting for my table
[e.g. bolds, fonts, center, etc] gets wiped out, except for the first
line and the column headers.  What is going on here, is access
overriding my formatting, and if so is there a way to decide how excel
will handle the data it recieves from access and format it on the fly?
Thanks in advance,

        -Zach

0
zach1 (1)
10/16/2006 2:21:52 PM
excel 39879 articles. 2 followers. Follow

2 Replies
401 Views

Similar Articles

[PageSpeed] 6

I import all my data using a macro through MSQuery.  This macro, besides 
updating my data can also perform any formatting that I wish.  This technique 
might serve you as well.......

Vaya con Dios,
Chuck, CABGx3




"zach@look.ca" wrote:

> Hi all,
> 
> I have data from a access DB that i am exporting into a table in excel.
>  This table keeps track of samples and what testing has been done to
> them in a lab.  When the data is refreshed the formatting for my table
> [e.g. bolds, fonts, center, etc] gets wiped out, except for the first
> line and the column headers.  What is going on here, is access
> overriding my formatting, and if so is there a way to decide how excel
> will handle the data it recieves from access and format it on the fly?
> Thanks in advance,
> 
>         -Zach
> 
> 
0
CLR (807)
10/16/2006 3:18:02 PM
Zach

If you create a refresh query in Excel to pull the data from Access
there's a tick box option to preserve cell formatting within the Data
Range Properties sheet of the query.
If you're doing a 'Transfer Spreadsheet' from Access I don't think
there is a way to preserve the formatting other than by creating an
Excel macro as the previous post suggests.

HTH

zach@look.ca wrote:
> Hi all,
>
> I have data from a access DB that i am exporting into a table in excel.
>  This table keeps track of samples and what testing has been done to
> them in a lab.  When the data is refreshed the formatting for my table
> [e.g. bolds, fonts, center, etc] gets wiped out, except for the first
> line and the column headers.  What is going on here, is access
> overriding my formatting, and if so is there a way to decide how excel
> will handle the data it recieves from access and format it on the fly?
> Thanks in advance,
> 
>         -Zach

0
10/17/2006 10:27:31 AM
Reply:

Similar Artilces:

outlook blocked access to the following potentially unsafe attachments
I am extremely frustrated by the inability of my friends to send me Level 1 ("Unsafe")attachments, such as URL's, Access databases and such without having to tell them they need to zip the file or change the file name extension. How can I fix this problem? I'm using Outlook 2002 with no service packs updated. Thanks Steve bashed at the keyboard and said..: > I am extremely frustrated by the inability of my friends > to send me Level 1 ("Unsafe")attachments, such as URL's, > Access databases and such without having to tell them > they need to...

Pivot Table not pulling all fields or data
Hi All........ Without getting too verbose, I have a 900 row by 26 column database I am applying a Pivot Table to. The code seems to run fine, but it is not returning some of the fields, and of course the related data. I have tried reformatting the entire columns I am pulling from but no joy......however, when I reformat an errant cell from General to TEXT, that row comes in........and/or, if I change the value in one of the missing cells, it will bring that row in. The code runs fine, and was mostly derived by recording a macro in XL2k, but the data cannot be trusted becau...

How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in Collumn C. Right now Both are defined by rows 4 to 114. I would like to be able to have the chart automatically redefine itself so if I put a value in C115 the chart would automaticaly set Y value range to be C4:C115 eithout having to manually define chart. Is this possible? If so how? I've tried OFFSET bu so far no luck. Hi, If you turn your data cells into a List, or Table in xl2007, the chart will auto expand. The named range approach will work if you set up the names correctly. See here for more info...

importing into register
I have successfully downloaded files from my bank into my checking account register. I have one account that that downloads my account info into a separate checking account, not the one I intend. I save the file then tried to import and it still imports into the other file. Bank support told me that the download may be matched to the other account and to turn it off, then re-point it to the correct account. I do not know how to do this. I even closed the incorrect account and did the import and it still imported into this account. Any suggestions are appreciated. You'll...

Problem importing dll
Hi I have an application that used some external com dlls. So in my application code i've imported those dlls as #import "path of external.dll" and i'm using smart pointers to instantiate those coms as IExternaPtr Obj("External.Interface1"); The problem i'm facing that those external com dlls are not mine so every time they are modified by thier owner i've to recompile my code too with the latest dlls otherwise my code does not work and i get Obj = NULL in the above statement. Actually those external dlls are of a software that i've provided integratio...

Exchange data backup
I'm worried emails backup of the small office. Does SBS2008 Exchange server has a direct backup capability of whole mail database? How to backup every night Emails from server to external harddisk? Does Exchange server needs to be stopped before backup? Thanks SBS2008 Takes care of it. http://blogs.technet.com/sbs/archive/2008/11/03/introducing-sbs-2008-backup.aspx look at the comments section Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Question or Seco...

Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save records, where as the system administrator is able to save the same information. Please advice on this error, what has to be done. I have disabled the windows user ID of the Database owner. Thinking of this made Dynasa as the DBO. Database is having enough free space available. Hi How big is the company database? Is it over 10GB? Regards James "Matthews" <Matthews@discussions.microsoft.com> wrote in message news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com... > GP Ver 6.0. Recently I...

Managing multiple worksheets 03-24-10
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I regularly create files with 50+ worksheets with interlinked references - mostly historical and projected financial statements. Is there anyway possible to group files in a folder in the tab bar at the bottom of the sheet for ease of navigation? For example, can I group together all worksheets for 2009, 2010 etc in separate folders that can be expanded or contracted for ease of navigation? <br><br>Thank you On 3/24/10 12:16 PM, dad4peanuts@officeformac.com wrote: > Version: 2008 Operating System: M...

drawing excel like grids on access reports
Hi All, I want to draw excel like grids on my access reports. The line should start from the top of each label in the page footer to the bottom of the corresponding text box in the page footer.(For each text box in the detail section, there's one unbound text box in the page footer to display totals). I don't know how to do this. can anyone please help me? -- from chanakya Baruva Can't you use rectangle or line controls in your various sections? These should work unless your sections are set to Can Grow. If this is the case, you may need to use the Line method ...

Why is Excel trying to access the network
I'm pasting some text into a cell - it did come from a website, but it's not a link or anything. It's just plain text - why the need to access the network? Maybe it's another cell, switch to formula view and see if you see something else. Because the formula view may not show everything, you might want to copy to another sheet so you can adjust columns to see your formulas better without affecting the column widths on the original. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm ...

cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) I gave you the INDIRECT option y'day, but received no feedback from you in that thread. Looks like you're more interested in knowing why? One simple hunc...

Access 2007 Ribbons
Hi All I am currently rebuilding one of my Access 2000 applications in Access 2007. On the Access 2000 application I had 2 Tool bars and a shortcut menu on most of the forms/reports 1. A "Print" tool bar and a "Print" menu for all Reports 2. A "Form" tool bar and a "Form" menu for all main forms 3. A Shortcut menu with Cut, Copy, Paste that could be used where needed. On Importing to the new Access 2007 database the shortcut menu is thankfully still available, although how you would rebuild or add to it is not clear. But, the toolbars and menus ar...

Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms, modules, and logic) used to CRUD the data in the tables. 1) Is there any way to separate the database from the code into separate files, eg. the db is mydata.mdb and the 'code is in a separate file, eg. code.mdb? 2) Say you have v1.0 of an app and the tables and attributes are populated with data. You then go and build v2.0 of the app, adding tables and columns to what already existed in v1.0, and perhaps moving some of the v1.0 attributes into different tables. What is the recommended way to unload/reloa...

Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels. I want to be able to have them listed under captions like company name, contact, address, city, etc.. so I can use the data. There is an empty row between each entry. Each entry is 3 or 4 rows. There are about 500 records so i dont want to manually set them up. Thanks Try tinkering around with these steps Assuming your list is in col A, data in A2 down (If data starts in A1 down, insert a new row for the co...

Access 2007 date function not working
I had a database in Access 2003 that I imported into 2007 and all works well except the date function in Reports. I have tried to go into reports and repair by adding a date field, but when I try to open the report and error box comes up asks for update parameter value for the date. The currrent date will not display in my reports, just (#name?) is in the date field. You would think trying to put the current date in a report would be easy. -- Thanks, Mark Use this --- =Date() -- KARL DEWEY Build a little - Test a little "Mark K" wrote: > I had a database in Access ...

Can I access the previous version of a saved file?
I overwrote an excel file by mistake, using the save as command to an incorrect file. Is there any way to recover the previous file before I "saved as" over it? Hi! I'm using Excel 10 (XP)......WinXP....... If I have an existing file and open it, make some changes, then do a SAVE AS and give it a different name, the newly "saved as" file is a completely *NEW* file and the original is still in tact with the previous file name. Try looking for the previous file name. Biff "JCC" <JCC@discussions.microsoft.com> wrote in message news:9CAD1748-1D5C...

Display comments as data #2
thanks a lot , this worked exactly as required, the comment go converted to data Now just one more thing . is the vice versa possible i.e if i have dat in column A can it be shown as comment in column B. the reason i need this is bcos i am shifting some data with thei comments to MS access(Hence the need to convert omments to data) processing them and again converting them to excel (the need to conver data back to comments -- sonik ----------------------------------------------------------------------- sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...

Outlook 03 Startup error msg
Just recently when I started outlook the following error windows started: DDESERVER WINDOW - Outlook.exe - Entry Point Not Found "The procedure enrty point GetIUMS not located in MSDART.DLL (2 times) DDESERVER WINDOW - Outlook Today - Entry Point Not Found "The procedure enrty point GetIUMS not located in MSDART.DLL (4 times) I've tried detect and repair, but that has not repaired the problem. MSKB doen't have any solutions. Has anyone else had this problem and found a solution to correct the problem? ...

Count invalid data entries
I am using the following macro to identify invalid data entries in cells with data validation applied. Sub CheckOrder() ' Application.CommandBars("Formula Auditing").Visible = True ActiveSheet.CircleInvalid Sheets("Configuration").CircleInvalid Sheets("Parts_TakeOff").CircleInvalid MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) & " Configuration and Parts_TakeOff Sheets") End Sub Is there a way to count the number of invalid data entries (red circles) and write the number to a particular ce...

How many recordset can be opened simultaneously for a MS-Access 2000 Database for adding /editing records
Hey Friends Can someone please suggest how many recordset can be opened simultaneously for a MS-Access 2000 for adding /editing records. I also want a comparison with MSDE for the same. Vikrant wrote: > Hey Friends > Can someone please suggest how many recordset can be opened > simultaneously for a MS-Access 2000 for adding /editing records. > I also want a comparison with MSDE for the same. Uhm... If I remember correctly that would be max. 20 connections. Successive CRecordset::Open(...) requests would fail. I don't know this parameter for MSDE. There's a limit in...

forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view. All the tables, queries, and macros are there. When I open up the database to add data, all the forms are there and can be used. The data is stored. So, it seems that the forms are still there, but just cannot be seen in design view. The database, when I open it up in design view, says Access 2000 file object even though I am using Access 2003 - could that be the problem? Thanks! You cannot open an entire database in Design View. Try opening it normally, selecting a form, and choosing Design View from the V...

Bulk Import Owners CRM 3.0
I added an "Owner" column to my import template and put the GUID for the record Owner in that column. The Owner field is not exposed in the mapping window when I import it. I remember testing this and having it work however. Is this supposed to work, or do I have to work around the fact that it doesn't work? Thank you, Lee Adler Hi Lee, It does not work, as owner field is not exposed for mapping in Bulk Import. -- Thanks and Regards. ManBhawan ---------------------------------------------------------------------------------------------------------------------------------...

Accessing Analysis Server 2005 64bit
Are there any troubles to expect when using Excel 2007 32bit against Cubes that are built on Analysis Server 2005 64bit ? ...

? concerning administration of Project Workspace access
In addition to having Project Server auto sync roles when team members are added (read only access to pws) and/or tasks are assigned (write access to pws), for the purpose of general public access, is it safe to add read only access to the site for certain AD domain groups? Thanks, Andy Novak UNT Not sure what your definition of "safe" is but, yes, you can add AD domain groups to the site to give them access. Jonathan <anovak@unt.edu> wrote in message news:45adb00f-b8fa-41f6-b08f-0564f7212150@r5g2000yqb.googlegroups.com... > In addition to having Project...

Data validation doesn't work if contents is added by pasting
Hi I've data validation set so that only the number 1 can be entered, but even this cannot be entered if an adjacent cell is a certain value. this works for direct entry, but not if the value is pasted in or added using the "drag handle". Is there any way to stop this happening as I just know somewones going to try and fill all the cells by draging the values down. Regards Jeff Jeff, You could disable "Allow cell drag and drop" in Tools | Options or... copy the following code, right click the sheet tab and choose 'view code'. Paste the code into the modu...