Recent content by strayerstu

Workarounds... I was able to import most of my data automatically and then tweak the last few manually. If this had been a table with thousands of records, however, that would have been unacceptable. Liv did suggest that I try exporting the spreadsheet to a text file and then import the text...

I did that after the first failed attempt. Formatting the excel cells as text made no difference during the import process. The only way I found to make a difference in the way access assigns the datatype (may not be the only way to influence, but it's the only one I've found so far) is...

I have office version 2000 at home and 2002 at work. This is what I've been trying... In Access, create a NEW database and name it. FILE >> Get External Data >> Import In the dialog, navigate to my excel spreadsheet, select it, and click Import In the import wizard: » Show...

I can't find the menu options to do that... How? I've been using the import function in Access to do this (it works on other, non-numeric data). Thanks.

I'm building a database at work to see if we can replace some of the "buhzillion" spreadsheets we currently use to track data on sites and employees across the country. I've set up the primary excel tables the way I want to import them, but Access keeps converting my Employee Numbers (mostly 7...