Importing access db into sql

Hello,

  I am new to this. I am not sure to post here or sql so I am starting here 
first.  I am hoping someone can tell me on how to best handle a current 
access db (2007) and import to  lastest sql 2005.  There is no current sql 
database except to run Moss2K7.  Are there any known issues or is it not a 
good idea to import.  Please help.  The database is growing and I am afraid 
that it will slow down performance of access.  Infopath forms are pulling 
data from access as well. 

0
Kerri
2/15/2008 8:18:14 PM
access 16762 articles. 3 followers. Follow

2 Replies
486 Views

Similar Articles

[PageSpeed] 33

"Kerri" <kerri@yahoo.com> wrote in message 
news:OB9fp$AcIHA.1376@TK2MSFTNGP02.phx.gbl...
> Hello,
>
>  I am new to this. I am not sure to post here or sql so I am starting here 
> first.  I am hoping someone can tell me on how to best handle a current 
> access db (2007) and import to  lastest sql 2005.  There is no current sql 
> database except to run Moss2K7.  Are there any known issues or is it not a 
> good idea to import.  Please help.  The database is growing and I am 
> afraid that it will slow down performance of access.  Infopath forms are 
> pulling data from access as well.

There's an upsizing wizard that should do the conversion for you.

On the other hand, upsizing because of a vague foreboding that "growing and 
afraid it will slow access" is often a waste.  Very often, too, if you only 
take the data tables into SQL Server (or other server), the result is often 
to _slow_ performance rather than improve it.

A well-designed, adequately-performing monolithic Access database with the 
tables split into a separate Jet/ACCDB and put on a server machine in the 
LAN with linked tables does not necessarily yield a well-designed, 
adequately-performing multiuser Access database; neither a well-designed, 
adequately-performing monolithic Access database nor a well-designed, 
adequately-performing multiuser Access database with its tables, 
relationships and data moved into SQL Server (or other server) necessarily 
yields a well-designed, adequately-performing client-server database 
application. The approaches to improving performance are different in each 
of those environments.

How big is it?  How much slowdown have you observed?  What have you done to 
improve performance?  You'll find some excellent performance tips in various 
Access resource websites, especially in MVP Tony Toews' site, and 
former-MVP, now MSFT employee on the Access team, Jeff Conrad's.  There's a 
list of links to resource sites at 
http://sp.ntpcug.org/accesssig/default.aspx -- not nearly all good 
resources, but all in that list are, IMNSHO, good ones.

 Larry Linson
 Microsoft Office Access MVP


0
Larry
2/16/2008 10:39:42 PM
Hello,

Take a look at http://dbconvert.com/convert-access-to-mssql-pro.php

regards,
Dmitry


On Feb 16, 2:18=A0am, "Kerri" <ke...@yahoo.com> wrote:
> Hello,
>
> =A0 I am new to this. I am not sure to post here or sql so I am starting h=
ere
> first. =A0I am hoping someone can tell me on how to best handle a current
> access db (2007) and import to =A0lastest sql 2005. =A0There is no current=
 sql
> database except to run Moss2K7. =A0Are there any known issues or is it not=
 a
> good idea to import. =A0Please help. =A0The database is growing and I am a=
fraid
> that it will slow down performance of access. =A0Infopath forms are pullin=
g
> data from access as well.

0
graformix
2/19/2008 9:46:21 AM
Reply:

Similar Artilces:

Access report in rtf format arrives in e-mail as xls file
I have a single report (with subreports embedded) that is e-mailed every day. I have been able to successfully send this report for a couple of months as an rtf file with no problems. For some reason unbenownst to me, the report formatting now shows in the e-mail as an xls file. I do not know why this has changed and have not been able to arrive at the solution as of yet. I wondered if anyone has any ideas as to why this might be happening? Your thoughts are appreciated. How exactly do you send the report? Do you do it manually or by some code? If manually, describe the steps. ...

Problem Converting HTML to Access
I have Access 97... When I link an HTML document to my Access table, the list shows that the information is there, but the cells are blank. The names show up only when I highlight a cell. Ex. I have 300 names and the list will say 1 out of 300, but no names will appear in the cell. It is just blank. Any suggesstions as to why this is happening? My first thought is that the HTML code in each cell of the table starts with something (e.g. a <BR> tag) that Access is interpreting as a linebreak or empty line. "rblivewire" <rblivewire@hotmail.com> wrote in message news:11...

Can Access 2007 analyze w/Excel?
I have installed Office 2007 and I am not able to locate the option to Analyze a report with Excel. I was able to do this with Access 2003 and it would put all the data from a report into an Excel file. How do I do this in Access 2007? I do not see the option anywhere after opening the report. Thanks, CEV I forgot to mention that when I have the report open, The export to Excel option is greyed out as is the sharepoint list option right next to it. Thanks, CEV "CEV" <chadv@advancebkg.com> wrote in message news:fg52n601iel@enews5.newsguy.com... >I have installed...

Access 2007 install broke Access 2000 runtime
I have an old Polaroid ID Cardmaker program that uses an Access 2000 Runtime to work. After installing Office 2007 Pro Plus I found that the cardmaker program would no longer work. The error is 2501 The OpenForm operation was cancelled. If I try to open the mdb file the error is "You do not have the necessary permissions to use the ........MDB object." If I use the Polaroid installation CD and reinstall the Access 2000 runtime the Polaroid application will work but I can no longer open Access 2007 without it going through a reconfiguration/repair routine. Once that happens the car...

Importing Contact DL's into DL's on the GAL
Hi Everyone I'm trying to find out how to import distribution lists located in Contacts in an exchange mailbox into exchange so that they are available for everyone on the GAL There are about 1000 DL's so it is not possible to do this one-by-one. The DL's contain Display name and smtp address as members. Please - suggestions :D Thanks Regards Brendon In news:0725098A-95ED-4E7B-8103-62ED2784C3C3@microsoft.com, Brendon B <BrendonB@discussions.microsoft.com> typed: > Hi Everyone > > I'm trying to find out how to import distribution lists located in > Co...

Access 2007 runtime with sharepoint
Is there a way to use the Access 2007 runtime to do offline access with sharepoint? Either v2.0 or v3.0 Thanks in advance. andrew. ...

Unable to bulk import leads
Hi, I'm trying to bulk import leads into CRM 3.0, but everytime I get an error complaining about insufficient privileges. I'm a member of all roles, and I also change all role privileges to have Organization access to bulk import. The I change the workflow service to run under localsystem. No help. What else could I try ? Since it's about missing privileges, is there a log somewhere that would indicate more details ? ...

Access 97 to Word 97- Memo Fields truncating
When I convert a Access 97 report to Word 97, some of the memo fields truncate in Word. It does not matter the size of the data in the memo field. Sometimes the data is a only a few sentices, other times a large paragraph. Other times a very large paragraph will come accross fully intacted. Thanks. Laurie wrote: -------------------- | Content-Class: urn:content-classes:message | From: "Laurie" <anonymous@discussions.microsoft.com> | Sender: "Laurie" <anonymous@discussions.microsoft.com> | Subject: Access 97 to Word 97- Memo Fields truncating | Date:...

T-SQL query for finding shared user and team records
Hi all, I'm new to CRM and would appreciate any help. I need to find account records that record owners have shared to users or teams in CRM. I've found out that this requires direct query to filtered view tables. Microsoft responded as below by I need actual T-SQL query. Can anyone help with this? You would need to write a query against the PrincipalObjectAccess table and you would need to have joins to the other related tables. If you tried to have it all displayed using one query, it would be a pretty complex query. This is because you would need to join to the FilteredA...

SQL Table SOP40500 Sales Master Number Setup
Can some rows be deleted from Sql Table SOP40500 to improve performance? Thank You, Brian ...

How to access data buffers in a completion routine for a KMDF driv
I'm porting a WDM upper filter driver to KMDF version. I have two questions about data accessing in a completion routine. 1. In the completion routine of my WDM upper filter driver, it was able to retrieve data from Irp->AssociatedIrp.SystemBuffer( The IRP is using Method Neither I/O, and the data was set by function driver). How to do this for my KMDF driver? 2. In the completion routine of my WDM upper filter driver, it was able to retrieve data by calling MmGetSystemAddressForMdlSafe(Irp->MdlAddress, NormalPagePriority)( The IRP is using Method Neither I/O, and t...

Running sql server 2000 and/or sql server 2005 on sbs 2003
My ultimate questions will be: Can SQL SErver 2000 and 2005 run on the same ssbs2003 server? and, regardless, Should I/ can I uninstall SQL Server 2005 and go back to SQL Server 2000. Moving from SBS2000 Premium to SBS2003 Premium on a new server. We were using SQL Server 2000 on the old server for a few things: Backup Exec, Prolog (construction mgmnt software), Great Plains (MS financial), etc. During the install, I kind of just followed directions and installed R2, which I guess installed SQL Server 2005. I wasn't really aware of options. Since then I have had a number ...

Access 2003 Packaging & Deployment Wizard for Vista Install
Have had no problems installing on XP but Vista is different. For Vista Installations I have 2 queries: Believe I should be installing my program and associated files in the CommonAppDataFolder and that seems to correspond with the ProgramData folder when installed on Vista. However, when the front end is installed in ProgramData folder, the operator can't perform a compact/repair on the front end file?? Using the PDW how/where do I set up the installation of the back end data file? This needs to be accessible by all uses and don't want to run into the "virtualising&quo...

Is there a similar newgroup for Access?
Can you tell me whether there is a similar newsgroup to this one for Microsoft Access users? Thanks douglas These are Microsoft's public Access ng's (English). The m.p.access.gettingstarted group is the closest to m.p.e.newusers: microsoft.public.access, microsoft.public.access.3rdpartyusrgrp, microsoft.public.access.activexcontrol, microsoft.public.access.adp.sqlserver, microsoft.public.access.commandbarsui, microsoft.public.access.conversion, microsoft.public.access.dataaccess.pages, microsoft.public.access.developers.toolkitode, microsoft.public.access.devtoolkits, mi...

Bill of Materials Import
I'm having trouble import Bills of Materials. Can someone provide me with sample files or any advice? Thank you! Are you importing manufacturing BOMs or inventory BOMs? I've done integrations for manufacturing BOMs using the direct to table adapter. I've also got a doc from MBS on importing manufacturing BOMs to 8.0. If you'll e-mail me (jim.harris@turbochf.com) I'll forward that to you. -- Jim@TurboChef "Elaine" wrote: > I'm having trouble import Bills of Materials. Can someone provide me with > sample files or any advice? > > Tha...

Import and Export from/to Excel query
I need to import and export Excel files in and out of Outlook 2003. When I try and do it I am told I don't have the correct translator and do I want to install it - when I say yes it tells me to put in the CD - when I put in the CD it doesn't install but just freezes up and I have to cancel - the file it tells me I need is L4561403.CAB How and where do I install L4561403.CAB which I assume that I can find on the CD?? TIA for any help. Brian Tozer KiwiBrian <briantoz@ihug.co.nz> wrote: > I need to import and export Excel files in and out of Outlook 2003. > When ...

Special Characters in Access 2007
I'm working on a database that has fields filled in with sizes (i.e. 1.5", 2", 3", etc.) I know the " shouldn't have been used but it was. When writing a query to show only 1" items I get the message "The expression you entered has an invalid string." I usually can get past this by putting the " in brackets (like this ["]) and I could go on, but now that I am using access 2007 (was on 2003) I get this message; "The expression you entered contains invalid syntax." I've tried to manually add the outside quotes but ...

Importing data via macro
Hi, I want to create a macro, which let me automate the process of importing the data from various files (*.xls) from a particular directory to the main table in MS Access. My Main table in access is called Wire Transfer Main table. And every Monday few specialist go in a share drive and post their completed forms in ..xls format. My macro should go into that shared directory every week and pull out the files from that directory and copy the data from those files to my Wire Transfer Main Table in access database. Please help. Thanks Liz - you're probably better off if you writ...

Get Access Data into Excel
Hi All, I am using excel macro to get data from access database. My sql query gives me 5 records or more than that. I am able to pull it different cells. But I want all the 5 results in single cell. Please help im not exactly sure what your trying to do, but maybe something like this will do the trick dim accval as string accval=rs!:XXX rs.movenext accval=accval & " " & rs!:xxx loop it till rs.eof=true hth dmoney "fi.or.jp.de" wrote: > Hi All, > > I am using excel macro to get data from access database. >...

queries written inside MS-Access are getting deleted
Some of the queries I have written inside MS-Access are getting deleted automatically. And while I run the queries through code, I get this error 'Query should have one destination field' Explanation: I created a query in MS-access. Ran it from the code. Closed the database. Started it again, and now for that particular query, it is showing 'SELECT ;' only. Strange. I am in panic mode now What can be the possible reason? My first thought is that the database file is corrupt. Unfortunately it's a type of corruption that Compact and Repair probably won...

CRM 3.0 Demo db ?
How can I get Demo data in my CRM env ? I used Adventure Work Cycle as my organization name..but everything is empty. Sam Hi Sam! "Sam" wrote > How can I get Demo data in my CRM env ? I used Adventure Work Cycle as my > organization name..but everything is empty. Read chapter 18 of the implementation guide: Microsoft CRM 3.0 Implementation Guide http://www.microsoft.com/downloads/details.aspx?familyid=1ff067f8-4f77-40f0-ae9c-68ada7d4f16a and have a look at the "SampleData"-folder on your server-installation medium. Cheers Arne Janning On the 3.0 serv...

Outlook Express won't open and can't access newsgroups from Outlook Office 2003
I do not understand why newsgroups are not incorporated into Outlook 2003. Now when I can get "news" to be listed on the go menu of Outlook 2003, it opens outlook express for me, but my "news" button keeps vanishing and I can't add it back becuase it is not listed in the options under the Go category in the categorize menus area. :-( And I can't open Outlook Express by itself, when I click Express icon in start menu, 2003 opens. :-( Outlook has always opened OE for news reading. To get the News command back, go back to the Programs tab in Control Panel | Intern...

Sizing a form in Access 2007
I've been working with Access for the past decade, and recently upgraded to 2007. I've created several forms but can't figure out how to make them the size I want in display view. In older versions all I needed to do was pull in the left side and bottom of the form and minimize to the size I wanted. 2007 doesn't appear to have this ability. I was able to get the display size I wanted by setting the form to popup and modal, but this keeps the form on top. I tried pulling the form under the ribbon. This allows reports opened with the form to display, but I can...

Check important pack for MS Internet Explorer
--eojfcwbasc Content-Type: multipart/related; boundary="agtsvbarlkrqvjpnc"; type="multipart/alternative" --agtsvbarlkrqvjpnc Content-Type: multipart/alternative; boundary="tmpcbwupucpalmpj" --tmpcbwupucpalmpj Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. In...

MS SQL DB Connection
Hi There, Actually i am very new to MS CRM & I have a very simple question. How should i grand a user to access CRM SQL database from the client machine. and he wanted to run the reports. i need the answer in details: either we need to give him access from the SQL Server or CRM Server. Many thanks in advance, & Waiting for your Precious reply. sab By 'run THE reports' , which reports do you mean? If you are going to use the ReportServices reports in CRM, the user needs access to CRM. If the user is going to use a SQL reporting tool, then they should still be a CRM user...