By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

PRoblems importing excel spreadsheet

P: n/a
When I import the spreadsheet, i get a lot of import errors because it seems
that access bases the import field type on the first row. So if a field has
a number in first row , then access encounters text in a later row, it will
give an error saying type mismatch.

The same goes for a number. IF it sees the number first, then a letter, it
will give an error.

How can I work around this without having to put some text in the first row
that has letters and numbers to indicate text field.

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
I have a very quick fix for one off importing. Set up the table in the
database with the correct field details and simple highlight the data
in excel (excluding the headings) and paste (by selecting the first
cell an 'control v') into the table.

"Danny" <da********@hotmail.com> wrote in message news:<gw********************@news4.srv.hcvlny.cv.n et>...
When I import the spreadsheet, i get a lot of import errors because it seems
that access bases the import field type on the first row. So if a field has
a number in first row , then access encounters text in a later row, it will
give an error saying type mismatch.

The same goes for a number. IF it sees the number first, then a letter, it
will give an error.

How can I work around this without having to put some text in the first row
that has letters and numbers to indicate text field.

Thanks

Nov 13 '05 #2

P: n/a
Two options:
Create a table first with the correct field types, and import into that
table.
Create the table as above, link to the spreadsheet and perform an append.

--
Shane Suebsahakarn
----
Head of IT
PAN Telecom
Tel: +44 (0) 870 757 7001

"Danny" <da********@hotmail.com> wrote in message
news:gw********************@news4.srv.hcvlny.cv.ne t...
When I import the spreadsheet, i get a lot of import errors because it seems that access bases the import field type on the first row. So if a field has a number in first row , then access encounters text in a later row, it will give an error saying type mismatch.

The same goes for a number. IF it sees the number first, then a letter, it will give an error.

How can I work around this without having to put some text in the first row that has letters and numbers to indicate text field.

Thanks

Nov 13 '05 #3

P: n/a
Create an import specification. You designate what the field types are that way.
Nov 13 '05 #4

P: n/a
Hi and thanks for your response.

How do I link to a spreadsheet?
also, how do I create a specification?
I think you can only do that with a regular txt import and not the .xls
format.
I do it using the command below

DoCmd.TransferSpreadsheet acImport,, "Database", aFile, True
Thanks
Danny
"Danny" <da********@hotmail.com> wrote in message
news:gw********************@news4.srv.hcvlny.cv.ne t...
When I import the spreadsheet, i get a lot of import errors because it seems that access bases the import field type on the first row. So if a field has a number in first row , then access encounters text in a later row, it will give an error saying type mismatch.

The same goes for a number. IF it sees the number first, then a letter, it will give an error.

How can I work around this without having to put some text in the first row that has letters and numbers to indicate text field.

Thanks

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.