Bad header on my first post. Sorry.
When I import a file using the Import Spreadsheet Wizard and I get to the
Field Options screen where it allows me to choose the fields and the Indexed
option, my Data Type option is grayed out. Shouldn't I be able to change
data types at that stage for each field as opposed to waiting until the data
is uploaded and changing in the table properties? Can someone tell me how to
turn that option on. Save a lot of time. Thanks
Mark 4 8656
This has been a problem with the Excel import wizard for years now.
Microsoft has fixed it in Access 2007, but the older versions still have the
problem.
The workaround I personally use is to create the table the way I want it
instead of using a Make Table query. Then attach the Excel, sheet, and use
Append query to populate it.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mark" <m.*******@snet .netwrote in message
news:PN******** *********@newss vr19.news.prodi gy.net...
Bad header on my first post. Sorry.
When I import a file using the Import Spreadsheet Wizard and I get to the
Field Options screen where it allows me to choose the fields and the
Indexed
option, my Data Type option is grayed out. Shouldn't I be able to change
data types at that stage for each field as opposed to waiting until the
data
is uploaded and changing in the table properties? Can someone tell me how
to
turn that option on. Save a lot of time. Thanks
Mark
Allen, so microsoft does not have a patch or hot fix for this for Access
2003?
Thanks
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:45******** *************** @per-qv1-newsreader-01.iinet.net.au ...
This has been a problem with the Excel import wizard for years now.
Microsoft has fixed it in Access 2007, but the older versions still have
the problem.
The workaround I personally use is to create the table the way I want it
instead of using a Make Table query. Then attach the Excel, sheet, and use
Append query to populate it.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Mark" <m.*******@snet .netwrote in message
news:PN******** *********@newss vr19.news.prodi gy.net...
>Bad header on my first post. Sorry.
When I import a file using the Import Spreadsheet Wizard and I get to the Field Options screen where it allows me to choose the fields and the Indexed option, my Data Type option is grayed out. Shouldn't I be able to change data types at that stage for each field as opposed to waiting until the data is uploaded and changing in the table properties? Can someone tell me how to turn that option on. Save a lot of time. Thanks
Mark
Interesting you should ask again, after Allen just wrote "but the older
versions still have the problem". Did you think that had changed between his
post and yours?
Larry
"Mark" <m.*******@snet .netwrote in message
news:km******** ********@newssv r23.news.prodig y.net...
Allen, so microsoft does not have a patch or hot fix for this for Access
2003?
Thanks
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:45******** *************** @per-qv1-newsreader-01.iinet.net.au ...
>This has been a problem with the Excel import wizard for years now. Microsoft has fixed it in Access 2007, but the older versions still have the problem.
The workaround I personally use is to create the table the way I want it instead of using a Make Table query. Then attach the Excel, sheet, and use Append query to populate it.
-- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
"Mark" <m.*******@snet .netwrote in message news:PN******* **********@news svr19.news.prod igy.net...
>>Bad header on my first post. Sorry.
When I import a file using the Import Spreadsheet Wizard and I get to the Field Options screen where it allows me to choose the fields and the Indexed option, my Data Type option is grayed out. Shouldn't I be able to change data types at that stage for each field as opposed to waiting until the data is uploaded and changing in the table properties? Can someone tell me how to turn that option on. Save a lot of time. Thanks
Mark
Hey Larry, its time to move out of your parents basement.
"Larry Linson" <bo*****@localh ost.notwrote in message
news:PsvCh.3053 $Cr1.956@trnddc 08...
Interesting you should ask again, after Allen just wrote "but the older
versions still have the problem". Did you think that had changed between
his post and yours?
Larry
"Mark" <m.*******@snet .netwrote in message
news:km******** ********@newssv r23.news.prodig y.net...
>Allen, so microsoft does not have a patch or hot fix for this for Access 2003?
Thanks
"Allen Browne" <Al*********@Se eSig.Invalidwro te in message news:45******* *************** *@per-qv1-newsreader-01.iinet.net.au ...
>>This has been a problem with the Excel import wizard for years now. Microsoft has fixed it in Access 2007, but the older versions still have the problem.
The workaround I personally use is to create the table the way I want it instead of using a Make Table query. Then attach the Excel, sheet, and use Append query to populate it.
-- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
"Mark" <m.*******@snet .netwrote in message news:PN****** ***********@new ssvr19.news.pro digy.net... Bad header on my first post. Sorry.
When I import a file using the Import Spreadsheet Wizard and I get to the Field Options screen where it allows me to choose the fields and the Indexed option, my Data Type option is grayed out. Shouldn't I be able to change data types at that stage for each field as opposed to waiting until the data is uploaded and changing in the table properties? Can someone tell me how to turn that option on. Save a lot of time. Thanks
Mark This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Ksenia Marasanova |
last post by:
Hi,
I have a little problem with encoding. Was hoping maybe anyone can
help me to solve it.
There is some amount of data in a database (PG) that must be inserted
into Excel sheet and emailed. Nothing special, everything works.
Except that non-ascii characters are not displayed properly.
The data is stored as XML into a text field. When I use pgsql it's
displayed good in the terminal. Now I run my script and print data
|
by: Mr. Bungle |
last post by:
When importing excel from access I am fully aware that one can import
directly into a table. Can you get as specific via code or something
to import data from an excel sheet to a FORM (Not Table) through a
command button. For example: cell C5 on the selected excel spread
sheet = textbox2 in the current form.
This is for a service repair type database. The service technicians
work out in the field and currently create their service orders...
|
by: Mads Petersen |
last post by:
I'm stuck in this code. Hope you can and will help me. I launch it
from excel.
I have made the following code work, but not as i whant. I need the
ranges to be working with something like xlDown.
eg. this only transferes the first record in the area.
..Fields("Uge").Value = ws.Range("A98").Value
Sub SelectMaster()
|
by: Janelle.Dunlap |
last post by:
I have an Excel spreadsheet containing a column of hyperlinks that I
need to import into Access. I have no trouble importing (in my case
actually linking) the spreadhsheet to the Access table, however the
column of hyperlinks lose their URL's in transit and no longer are
active links. To try and fix the problem I am using this bit of code
in my Excel spreadsheet to copy the URL of each hyperlink into a new
column that can then be...
|
by: ScardyBob |
last post by:
Hello,
I am having trouble importing data from an Excel Worksheet. When I try
to import the data, everything works except certain columns that
contain dates, where it replaces the date with a null in the access
table. To import the data I do the following.
1. Create a table based on the excel spreadsheet setup with the
following query
sSQL = "INSERT INTO " & TblName & " SELECT * " _
| |
by: Grip |
last post by:
Hi,
I have gone throught the group and Microsoft's online help and have
seen many suggestions but I am still seeking clarity:
1. I have an excel spreadsheet. Column A contains text that may be
greater than 255 characters.
2. I have an access database. I link (not import) to the contents of
the excel spreadsheet. In the design view in access, Column A has the
data type "memo".
|
by: Mark |
last post by:
When I import a file using the Import Spreadsheet Wizard and I get to the
Field Options screen where it allows me to choose the fields and the Indexed
option, my Data Type option is grayed out. Shouldn't I be able to change
data types at that stage for each field as opposed to waiting until the data
is uploaded and changing in the table properties? Can someone tell me how to
turn that option on. Save a lot of time. Thanks
Mark
|
by: BigAl.NZ |
last post by:
Hi Folks,
I am trying to make a database for the classic scenario of customers,
products, orders. Its been a wile since i played around with
databases.
I have four tables:
Customers(customer_id, address,first_name......
Products(product_id,distributor_code,manufacturer_code......
|
by: Merlin1857 |
last post by:
Its great producing data for users to look at in your web pages and generally that is sufficient for their needs but sometimes you may want to supply your user with the data in a form they can actually do something more with. This code shows you how to display data from your database and then how to give that data to the user in the form of a useable Excel spreadsheet which they can then take away and play with themselves. The way I have shown...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |